I want to be able to reference the name of the worksheet, ie the tab name.

In a header/footer the worksheet name can be entered by using &tab.
This does not seem to work in a cell.

The formulas for inserting filenames with woksheetname etc are difficult to decifer as to where the woksheet name is.

Has anyone needed this before ?

Please Help !