Worksheet Referencing

[Rob Davies]

How can I create a formula that references a worksheet
name stored as a value in a separate cell in a worksheet?

 

[Ron de Bruin]

Use Indirect

with a sheet name in B1
=INDIRECT(B1 & "!$A$1")