Do not ask me to write the complete code. I will give you a push in the right direction.
ACTIVESHEET.PICTURES.INSERT ("path to your image")
So, if we make a variable called "PICPATH", and assign it the value of a cell (where the name is stored), you can make a custom picture path for each person. As in:
PICPATH="C:\somefolder\images\" & activesheet.range("A1").value