vba vlookup picture

Hi guys,

There are already some threads regarding picture reference, but none answer my questions.
Here is my situation: I have 2 different sheets.

In sheet1 is my album with colomn A (Name of the picture) and colomn B (the picture itself). It is important to notice I have more than 100 rows (100 pictures), reason why vba is a must.

sheet2 contains other data, starting with colomn A (the name of the picture), each name apprearing several times (up to 10 times), and colomn B where I would like to see the picture corresponding (basically as a simple vlookup would do but with an image).

The DB in sheet1 is often updated with new pictures and sheet2 reaches now 1000 rows, reason why I cannot work manualy.

Can anyone provide help on the vba code please ?

Thanksss

Please notice the "http://www.mcgimpsey.com/excel/lookuppics.html" solution is not working here as the picture are saved on the excel sheet only and not on a personal drive.

Cheers !