Insert Images into Cells from Folder

Hi All,

I have a list of image names in column A that all belong to to the same folder. I would like for the pictures to show in column B beside the name that was already there. Attached is an excel file.

Sheet 1 is the pre-macro running
Sheet 2 is what it should look like

Note- Sheet 2 only has one image but every cell should fill in.

My main issue is it stops running if it can't find the picture.