creating Linked cells from current workbook Dynamically with multiple cell values

Is the target file open or closed?

Although I can't help you with the VBA code, I'm interested in the meaning of:

GPO (what is GPO)?

GPO = "Group Policy Object" instituted by Microsoft Active Directory to restrict actions on the workstations for Security.

Because of this Excel Restriction I can only use Formulas and Functions in a worksheet.

To be able to run Macros and VB, I would need special privileges granted to my workstation and a Certificate would need to be issued
and that takes an act of congress to get... Government at it's finest..

thanks for the explanation.

I thought that I had replied earlier. Clearly not. You have only one remaining possibility. However, I guarantee that it'll not be possible without Congressional/Presidential approval. There is a free add-in which contains a function called INDIRECT.EXT. Download it and install on ALL PCs that will open the file. I see that you're using Excel 2010. It works fine on that version of Excel. I believe it can be made to work on 2013 as welll.

The add-in is called Morefunc. Google it if you are able to go down this road. If not... then you're up that famous creek without a paddle...

Thanks,
That's not approved.
Unfortunately I have to work within the constraints of the approved application, No Downloaded files PERIOD..

If the app was approved I could have it installed, but I checked the List of approved apps and it's not there..

I will have to build the formula manually and drag down to populate the cells.

Thanks Anyway.