Reference a sheet name through a cell

[oks]

Hi
I have som sheet in a workbook with
column of different values

Then I want to put the sheet name i a cell
and reference the sheet through that cell


ex.
Now I'm in sheet-d
A B C
1 sheet-a sheet-b sheet-b
2
3

Cell a3: = sum(A1!B1:b25)

ok

 

[papou]

Hello oks
Use INDIRECT:
=SUM(INDIRECT(A1&""!B1:B25"",TRUE))

Cordially
Pascal