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!

Hello MrSandman,

I added macros to your workbook to automate the picture selection process for you. The good news is it works. The down side is the file is too large to attach to post even when zipped. If you give me your email address, I will send you the workbook. You can either contact me by private message, or you can email me at LeithRoss@gmail.com

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello MrSandman,

I added macros to your workbook to automate the picture selection process for you. The good news is it works. The down side is the file is too large to attach to post even when zipped. If you give me your email address, I will send you the workbook. You can either contact me by private message, or you can email me at LeithRoss@gmail.com

Sincerely,
Leith Ross

PM Sent. Thanks!