I'm having an issue and I can't figure out how to look it up to get a
proper answer, nor can I find an answer in the books that I have, so I
figured I'd try here -- I have a spreadsheet that I am trying to link
to other spreadsheets. In one column, I have data that tells me what
the other spreadsheets are that need to be linked to. I want to look
up a few different cell values from those other spreadsheets to
manipulate, and I want to use it by using the variable in the column
to look up the data.

For instance, the column is F, and if the value for F3 is "File01" I
want to make J3 do the following function, but with the "File01"
dynamic based on what is in column F. The function is:

=[File01.xlsx]Template!$M$2

Any help would be appreciated!