Thanks, but how do I insert that into the file path so excel recognizes that
as a function and not as just more text?

For example - \\computer\my files\123 main st\[123 main st.xlsx]sheet1a1

What exactly do I replace "123 main st" with if I want it to look in cell A7?

"Harlan Grove" wrote:

Sheeloo wrote...
Try INDIRECT...
....
eg
=Sheet1!A1
can be replaced by
=INDIRECT("Sheet1!A" & B1)
where B1 contains 1
....

Or avoid inefficient volatile functions and use

=INDEX(Sheet1!$A:$A,B1)