Copying photos based on a lookup table?

I have attached a file with 2 worksheets. On the 1st worksheet it is titled Setup. At the bottom of this worksheet is a table where the information is populated beforehand based on name and title along with a photo (which will be their signature). At the top of this worksheet are 2 dropdown lists for Checker and Approver based on the "names" from column A. When a name is chosen from each dropdown menu what i would like it to do is take that name's signature and automatically paste it into the appropriate field (checker or approver) in the "report" worksheet. I would like this to happen automatically as soon as the name is chosen. Then on the "Report" worksheet under each signature i would like it to concatenate the appropriate Name-Title. This can be done with a lookup table, i assume? I've searched on here and couldn't find much info regarding such a project. Any help is appreciated!