Referencing text from one cell into an equation in Excel
Option1:
='A1'!A1
should work.
Option2:
Click the cell that contains the data you want to link to, and then click Copy Button image on the Standard toolbar.
Click the cell you want to link from, and then click Paste Button image.
Click Paste Options Button image and then click Link Cells.
Option3:
=INDIRECT(‘$A$1′!A1)
You should use the INDIRECT function to turn a string into a reference.
=INDIRECT("'"&$A$1&"'!D16")