Insert images into respective cells according to filepaths stored in a range
Here is a macro to insert image files into respective cells, according to image filenames or full filepaths.
File names/paths are stored in "D" column, and pictures are inserted in "A" column, in the same row.
If you have only the list of file names, use the first macro ("Short Name"). Change the macro so it refers to the folder where image files are stored.
If you have a list of image files as full path+filename, use the second macro ("Full Path").
I recommend using the second method.
To keep your list of image files updated, use this: http://www.excelexperts.com/VBA-Tips-List-Files-In-A-Folder.
Look at attached example to see how it works.