Retain References between 2 files (with change in sheet name or file name or location change)

[suhas.sharma]

Hello,

I have two files named A & B. File A has sheet tab 1 which has information from A1 to C3 which keeps on changing.

In file B, I have references to file A. File A name, Sheet name in file A or location of file A can change.

In file B, i want to create a reference to file A using some sort of concatenation like

Path of file A & File name & Sheet Name & cell no (all of these variables (path, File Name & Sheet name) will be placed somewhere in file B.

Any ideas???