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 Re using = to get data from a sheet based on a cell name @Fatdave42 , the solution @Hans Vogelaar gave will do that More specifically the INDIRECT("'" & A5 & "'!F1") portion will return the value from cell F1 on the sheet named in cell A5 Note I did find a typo in the formula missing a quote so that might have been part of your problem The MID function then extracts up to the next 32 characters This is an excessive number but because sheet names cannot have more than 31 characters it ensures the full name is returned whatever it may be Here is the full Excel formula to display the sheet name in a cell;
1
