formula for reffer to sheetname.....

[jamiguel77]

2) i have 100 sheets, in first sheet named: General, and the rest: 4-00, 4-01, 4-02 and so so on...
in sheet General, have the names of the sheets in the cells: A1 to A100
4-00
4-01
4-02
....

my question is: in B1 to B100 i have this formula: ='4-00'!$A$3 i want change 4-00 by A1.... how to, i want take the name of the sheet of A1 cell or A2 or A3...

thanks

 

[jamiguel77]

i try: =CONCATENATE("=","'",A1,"'!$A$3") but not get the value...

 

[Peter_SSs]

Try
=INDIRECT("'"&A1&"'!$A$3")