Goto INSERT|NAME|DEFINE
Type SheetName under "Names in workbook:"
Type =GET.CELL(5,A1) under "Refers to:"
Then go into a cell on your worksheet and type SheetName
It will return the Sheet name
This only seems to return the name of the sheet that was active at time name was set up