Copy a picture that I click to another sheet.

Hi all new to the forum
I am trying to make a spread sheet for work that has a load of pictures on sheet one that i can click one of and then have that hyperlink to sheet 2 and copy the picture i clicked onto that sheet.
Is this possible? there is about 100 pictures i will need to do this for

Any help will be gratefully revived thanks.