Try
=INDIRECT("'[filename.xls]sheet"&CellAddress&"'!$A$1")

replace filename.xls with the name of your file
replace CellAddress with the address of the cell containing the digit of
interest


"Stan Halls" wrote:

i have 2 files, one file has 6 tabs named week1 - 6 filled with data,
the 2nd file has a fixed cell that has a number from 1 - 6 ,
in a cell on file 2 i want to check the fixed cell and depending on the
number get the results from the corrosonding tab on the other file
so if the result in the fixed cell is 1 then sum filename sheet1:a1 if 2
then filename sheet2:a1 and so on ,
any ideas
Thanks in advance for any help