Use INDIRECT

Let say that A1 has the sheet name and that we want to reference A1 of that sheet. The formula will be:

=INDIRECT(A1&"!A1")

Related Q&A

• Selecting a sequence of sheets in Google Docs / Spreadsheets
• Dynamically Building Array Of Sheet Names From A Range Of Cells

Yes, by using the INDIRECT function:

A1: Sales Report - WB 10.06

Then you can use:

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