Using a formula, is there a way to display worksheet (tab names) in a cell?
For example, I have 3 worksheets with names One, Two and Three. In cell A1 in
each woksheet, I would want to see the worksheet name for whichever worksheet
I am viewing. I do not want the name to change in the cell each time I click
on one of the other two spreadsheets, similar to what happens with
=CELL("FILENAME"). I also do not want to see the entire path for the
worksheet.