=INDIRECT("'["&A1&"]"&B1&"'!B2")

file name in A1 and sheet name in B1

--
Regards,

Peo Sjoblom

(No private emails please)


"BorisS" wrote in message
...
I want to have two cells where one tells me the name of a file, and the
other
tells me the name of a sheet tab in that file. I would like to be able to
use those two values in a cell to complete a reference to a cell (let's
say
B2 of that file's tab). What is the formatting for this?

Thx.
--
Boris