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.