On Nov 19, 1:11 pm, David Sauder wrote:
Try using the indirect function. If you can use simple text formulas
to get (for example) this text in cell A1:

[File01.xlsx]Template!$M$2

Then in another cell enter =indirect(a1) and that should return the
value in File01 cell m2.

David Sauder

I came up with a similar solution to the above idea that I thought I
would post in case anyone is interested and sees this thread. In this
case, I knew that I would be calling from data in a decent number of
other templates, so I set up another spreadsheet in it called "Key"
which lists the data that I could be referencing in the main one.

I then did an INDEX / MATCH formula to match the data in my cell
(File01) to the key, which then has the data that I want in it
( [File01.xlsx]Template!M!2 ). In such a way, I can quickly call upon
the data for everything that I want by using this formula:

=INDEX(Key!$A$1:$T$101, MATCH($F3,Key!$A$1:$A$100, 0), MATCH(J$2, Key!
$A$1:$T$1, 0))

Although it was a little more cumbersome than I originally hoped it
would be, the "Key" spreadsheet will allow me to be able to manipulate
it to get more data that I might use off it, so it might be worthwhile
after all!

Thanks for the suggestion!