I was able to create the link pictures to a drop down list following the Ron's instructions
Select Sheet2 and turn
off Grid Lines
...<Tools>Options><View tab>Uncheck: Grid Lines
1)For each picture to be displayed:
1a. <Insert><Picture from file> (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the dropdown list text:
Example for a picture of an Elephant:
Names in Workbook: picElephant
2)Build your data validation list on a cell in Sheet1 and pick one of the items.
3)Create a dynamic range name that refers to that cell:
Names in Workbook: ShowMyPic
...or whatever cell you chose.
4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.
5)With the picture selected, type this in the formula bar, then press [Enter]:
The picture will be replaced by the picture referred to by the dropdown list.
I went back into the file to added new pic[name], the ShowMyPic does not bring in the new images.
The range names
for all the new images match the originals so I don't understand why the new images are not captured. Is there an additional
step required when modifying the original pictures in Sheet2?