I have a worksheet with a few cells merged together (cells F12:H14). In these merged cells I want to automatically load a picture based on cell value in cell "I13".

Location of pictures:
The pictures are *.jpg files within the folder "pictures" which is in the same folder as the excel file. So the path must be relative.

Loading:
The picture must be loaded automatically when the worksheet is opened.

Sizing:
The picture must be autmatically sized to the size of the merged cells (F12:H14) and as both horizontally and vertically centered.

Duplication:
The sheet with the picture insert will automatically be duplicated based on the number of rows in a "data" sheet. The multiplied sheets gets automatically renamed to the cell values of the rows in de "data" sheet. So I guess that has someting to do with naming or placement of the VBA code?

I cannot find any VBA that fullfills my needs (as ever ). Can someone help me with this.