how to use a cell to enter a filename in a formula

[Guest]

I am building a filename from two cells(A2, B1) and concatenating them into a
third cell(F2). How do use this third cell in a formula in a forth cell(B2)
to bring a figure from the file named in the third cell?

 

[Guest]

the indirect function will turn a text reference to a result but it will only
work if the remote workbook is open.

 

[Guest]

Thanks Paul, I'll try that.

the indirect function will turn a text reference to a result but it will only
work if the remote workbook is open.