I am trying to figure out a way in Excel to reference the name of the sheet
tab using a formula. For example, in a new Excel document, the name of the
first sheet tab defaults as "Sheet 1". I am trying to write a formula in cell
A1 that would reference and show "Sheet 1" so that if I renamed "Sheet 1" as
"Accounting", cell A1 would now read "Accounting.

Thank you in advance for help anyone can provide,
David