Insert Images based on cell name before "-"

[briguy123]

I currently have a macro that pulls a list of Part Numbers that needs to get done for the week. I would like to use another macro to add a picture beside the part number cell to give a little visual of the what the part looks like.

I already have a macro that does this but not how I want it... below is a list of why it isn't working.

Main Issues

-Picture files are not exactly named after the part number ex. ACTUAL PART NUMBER = 1234-01,1234-02 PICTURE FILE NAME = 1234
- jpeg and png files in it
-Some picture files are accurate to one but apply to many ex. ACTUAL PART NUMBER = 1234-01, 1234-02 PICTURE FILE NAME = 1234-01
^ For this example I want the 1234-01 to also apply to the 02.

I can send my code that I have right now but it is doing weird things like duplicating and I also had to add an abbreviated Part Number column to try and help.

Here is a picture of the formatting,

Thanks