Pull images from URL(s) into excel using cell data as part of the URL(s).

I would like to put the reference code in 10 cell values and then 10 images to appear after clicking a macro button, using part of the data in the first set of cells to generate the image source (URLs). This can be in VB/macro and must work on Excel 2007+ for PC and Mac (2011+) The spreadsheet for it to work on is attached. Project needs to be done within 2 working days from awarded project.