If your sheet name is in A1 and you want to reference a cell on that sheet in C2, use this formula =INDIRECT("'"&A1&"'!C2") I use Excel a lot, not just for crunching numbers, but for creating teaching resources, lesson planning, managing my accounts and invoices and various other uses One feature that I often use, is the ability to have the sheet name appearing inside a cell in the spreadsheet so for example with my invoices Excel Pull Data from Multiple Sheets Based on Cell Criteria I have a sheet that has multiple tabs One tab is a summary tab and on this sheet I would like to pull data from other sheets This is the Summary Sheet Another tab is titled "Doubles" Based on the name in Column A, I would like to pull the percentage in Column B and fill it in on
Microsoft Excel Create An Automated List Of Worksheet Names Journal Of Accountancy