Automate External References
 

I have an excel sheet that has external references to other sheets. Is there
an easy way to automate the external references to be added to my
consolidated excel sheet? Below is an example of the consolidated sheet.

Consolidated Sheet
a B
1 Excel File 1 A12
2 Excel File QCA A12
3 Excel File PBC A12
4
5


The rows reference a differenct excell file but alwas the same cells in the
file.

Thank you