As your requirement is vague and you seem to expect someone to program this for you it is not really a surprise that you haven't had a reply.



If you modify your worksheet in line with the description at https://www.gmayor.com/photo_gallery_template.html that might work for you - otherwise it seems that what you are describing is mail merge and that requires a particular syntax for the graphics merge - see https://www.gmayor.com/mail_merge_graphics.htm and https://www.gmayor.com/mail_merge_graphics_addin.htm

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com