can formula to read sheetname from a cell?

[Guest]

I have a formula with references to other worksheets. Is there a way to have
the formula read the sheet name from another cell?

Worksheet(1)
Sheet name Formula I have now: Formula I hope for:
Bob =Bob!c3 =sheetname(This sheet A1)!c3

Jill =Jill!c3 =sheetname(This sheet
A2)!c3
Peter =Peter!c3 =sheetname(This sheet A3)!c3


Thanks,


Todd

 

[Frank Kabel]

Hi
=INDIRECT("'" & A1 & "'!C3")

 

[Guest]

One way

=INDIRECT("'"&This_Sheet!A1&"'!A1")

Regards,

Peo Sjoblom