Duplicate, rename, and output image files to folder based on criteria in Excel Column

[S Thibault]

I have a list of part #'s stored in MS Excel, with each part number containing a hyperlink to its corresponding image file. However, there is an issue where multiple part numbers are linked to the same image file. My objective is to ensure that each image file is duplicated as needed and given a new name that matches the corresponding part number. Essentially, I require the duplication and renaming of the same image file multiple times based on part number in column A.

To address this challenge, I have utilized VBA to rename files within their respective folders. However, this approach only resolves half of the problem. In addition to renaming the files, I also need them to be duplicated and renamed based on the part numbers listed in the corresponding columns. (see attached screenshot). I am open to any ideas (VBA, scripting, tools, etc).

Duplicate Image Example (1).xlsx