Is it possible to use a cell text as a sheet reference in Google sheets. I have a spreadsheet with many sheets and want to reference a sheet name from text in a cell rather than having to put the sheet name in each time.
Somewhat guessing what you require (examples often help) if say you have a couple of sheets named:
and those names in A1 and A2 of Sheet1, then a formula like:
in Sheet1 should return the value of B2 from Sheet2 and if copied down one row, the value of B2 from Sheet3.