Looking for a VBA way to have excel rename a picture based on cell contents

[shophoney]

Hi

I have product photos and would like vba to rename a selected photo to the cell contents.

any thoughts would be great.
My staff take hundreds of product photos and create the info on an item. I would like them to click a macro select the photo to rename it the model the just created.
Thanks

 

[Crystalyzer]

Any clues as to the structure of the worksheet and where the data is laid out in relation to the photo?