Text from one cell in a formula in another

[Scooter]

Is there a way to use the text in one cell (A3, for example) in a formula in
C3 to identify the sheet (in the same workbook) to look on for data?

I am looking for the value of cell C35 on the sheet named in A3.

Basically, this is what I think C3 needs to look like:

=(_textfromA3_!C35)

I cannot figure out how to tell it to do this with a formula that I can
paste in lots of cells.

 

[T. Valko]

Try this:

=INDIRECT("'"&A3&"'!C35")

 

[Scooter]

I knew it was going to be embarassingly simple.

Works like a charm. Thanks.

 

[T. Valko]

You're welcome. Thanks for the feedback!