Pull a value from whichever sheet name is typed in a cell, with INDIRECT.
Copy this formula
=INDIRECT("'"&A2&"'!B2")INDIRECT turns a text string into a live reference. Building the string from a cell (the sheet name in A2) lets one formula point at different sheets as the name changes — great for dynamic dashboards.
=INDIRECT("'"&A2&"'!"&"D10")→8,400Reads D10 from the sheet named in A2.
Sheet names with spaces must be wrapped in single quotes. Including them always is safe.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.