Pull pictures from other workbook?

[lpking2005]

hi,

I have a spreadsheet that needs to pull a picture from another workbook which contains loads of pictures.
Each one of the pictures has a product number also, so what i want is when I enter the order number, it pulls the correct picture across into a certain cell or position on spreadsheet.

Any help would very much appreciated! Thanks!

 

[lpking2005]

there must be a way to pull pictures somehow?

I have tried embedding pictures into comment boxes, that works if your copying to another cell on the same sheet but not another workbook.

How about calling for an embedded object from another cell?

Im really not sure on this one.

Any help please!