Dynamic Picture Viewer

Hi all
I am new to excel, and eventhough i went through a lot of similar examples, i couldnt understand it.

heres my problem

I have a number of pics in sheet 2,
and i need to display them in sheet 1, according to a given pic name,

if the pics in sheet 2 are named from 1,2,3 etc.

then i need to swap between the pictures 1,2,3 according to a cell value which matches the name.

I tried messing with the camera tool and offset functions, but i failed in vain.

and please, i dont know the first thing about macros,


thankyou

Sounds like a macro question to me. If it doesn't get answered here, try reposting under the VBA/Macros category rather than Excel General.