Insert a person's picture based on their name being entered into a cell

[Sparky]

I have column A blank in my employee roles sheet. When I enter their names in column A VLOOKUPS populate other columns with associated data. In the last column used (F) I need to display their pictures automatically. I have the employee pictures on another worksheet in the same workbook. These are all listed alphabetically.
The employees quite often move to other roles hence the reason for the request for help.

I realise that this can't be achieved with VLOOKUP. How do I get the cells in column F to display the employee pictures?

VBA or formula?

I am using 2010.

Thanks in advance to anyone taking the time to look at this.

 

[Haluk]

See the links below;

https://www.mrexcel.com/forum/excel-questions/723293-how-pull-image-using-vlookup.html

and,

https://www.excelguru.ca/content.php?279-VLOOKUP-for-Pictures

 

[Sparky]

Haluk
Thank you. I will try them.