In Excel, workbook have a tab that displays the name of its worsheets. Excel
gives you the ability to customize the name of each worksheet by editing the
name of the tab.

What I would like to be able to do, is to have the ability to link the name
found on the worksheet tab name and insert its content unto a cell (any cell)
in the spreadsheet.

Yes, i know that it is possible to right click the workshhet tab and re-name
it.
Yes, I know that I can go to page set up and edit a header.

I want to do both in one operation

Any suggestions?