how do I display the name of a worksheet automatically in a cell?

A

Archie N.

I use a rolling 12 months spreadsheet that has a sheet for each month of
activity, and is a home sheet of rother workbooks to connect to and pick up
relevant data. As I delete old sheets and add clone new ones I have to
manually change the title cell name of the sheet to the proper month. I would
like to be able to just change the name of the tab, (example: "Sep_05"), and
have that name propagate to the title cell on that page.
 
Top