Well good luck with this. Excel is for calculating complex mathematical equations, not an interface for images. Even if the code will insert it into the row and column you wish, if the images are not all the same size, it will WRECK the formatting of your columns, making them unreadable.
Which part of the scripting are you having issues with?
Here is short code for you to play with in the sandbox!
picpath = "e:\pictureshare\smiley1.jpg"
.LockAspectRatio = msoTrue
.Width = 75
.Height = 100
.Left = ActiveSheet.Cells(1, 20).Left
.Top = ActiveSheet.Cells(1, 20).Top
.Placement = 1
.PrintObject = True