Attached are 3 files. The ppt tries to explain - but I'm sure it's not enough.
In essence, I have 8 field agent who report the status of their projects in their own excel 2007 file. We have a master file with a consolidation worksheet "PI - Read Only" that have automatic links turned on and reads (equals) text from the agents reports using a vlookup. Only the manger has access to this file. This updates the consolidation worksheet on the fly. The consolidation worksheet essentially pools the information into a master repository from the field agents files which reside in separate sub-folders on the same server. The master consolidation file also has two template reports "TFM" and "QA" that read the consolidation worksheet and they populate the "TFM" and "QA" template report cells accordingly. This all works, no problem. Now, upper management would like to see updated status pictures on the "QA" report. We can include place-holder cells on the fields agents reports where they can place their images, but do not have the know-how to copy images from their report onto the "QA" report template. We would like it to be an automatic link like the text, but somehow I don't think that's possible without a macro that can be executed from either the master file or from each of the agents files.
I've included the master consolidation file as well as an agent's file.
Thank you for showing us how this can be done.