Re Reference a worksheet name in a cell as JBeaucaire has suggested in the thread you posted in previously, try =MID (CELL ("filename",A1),FIND ("",CELL ("filename",A1))1,256) to return the sheet name to a cell Copy these formulas for any linked cell or sheet If you want to get the file name, sheet name or path from another cell or workbook, you can use one of the following formulas Instead of "A1" you insert your cell reference Worksheet name (example "Formulas")I have 0 exp Note I get the cell reference via Named Range, as such I am stuck with what I have
How To Name Sheets Based On Cell Values From List In Excel