Display Photo from Folders

Ok so I have research many options and cant get one to work. What I have is a dropdown menu and based on which value is selected I want a photo displayed.

What I have right now is the main sheet with a dropdown and a 2nd sheet with a table of the dropdown values in one column and the matching file location. I want these in a folder so if someone needs to update a photo they can make a new file with the same name and just copy it into the folder without messing with excel. I have it set up so when the dropdown is selected, below it is a cell that shows the file location (I'll hide this once it works) and I was trying to just have a macro or vb code to use that to display the photo.

I had it set up prior to work with photos on that 2nd sheet but trying to convert. I attached a demo below. Thanks for any help

Photo Demo.xlsm

Thanks, that's what I was looking for. 1 issue is with photo sizing. I know I can adjust the photo box but I would like to have the image resize to fit the area. Right now its displaying a small section of the overall photo. Is this in the image properties or will it need to be done via the macro settings?

Nevermind, I found the property setting field for it. All good. Thanks!