VBA code to inserti image into cell not working

Hi Everyone

This is the first time I am posting to this forum; I am a bit lost with a VBA code that I found on a youtube guide video.

I am trying to have this code display a picture in a spreadsheet based on the cell text. I have a car's list, and for each of them, I want to display the logo instead of the name, but when I run the code, it clear the cell instead of showing the picture. I have the logos in a folder on my computer in PNG format as in the video.

I will attach the excel file with the cars list and the code for you to understand better and also, I have a GIF file where I replicate the issue (i wasn't able to upload this one same as the document)

Thanks a lot in advance to all who decide to help me and to this great forum

Hi, Keebellah. Thank you so much for taking the time on looking into this.

I will now attach the Macro-Enabled file with all pages in it so that you should be able to see the code, and no links will be required.
I hope this enables you to get to the code.

I would like the car logo to go in the CAR CHECK sheet so that each cell containing the car name will be changed with the logo