Dynamic Image Gallery

[gamecock21]

I am attempting to create a dynamic picture gallery for 1-100 pictures. When I select image 1, I want the image and comments associated, on sheet 2, to be presented on sheet 1.

I have attached the worksheet- the VBA is:
"

If Target.Address = "$C$2" Then

item_input = Sheet1.Range("C2")

If item_input = "1" Then Sheet1.Image1.Picture = Sheet2.Image1.Picture.

"


Picture Template.xlsx

I can't seem to get the comment/picture function to work correctly and I'm attempting to use a IF(VLOOKUP..