How to auto insert photo in excel with matching cell and pic fil

I have a list of photos names that I would like to auto insert the photos into the cell according to the name.
For example: in cell B1 is pic1234, in cell W1, insert the picture named pic1234.jpg in f:/photo/
and repeat with B2,B3, so on.