Insert worksheet name into cell?

[sparky0303]

Is there anyway to automatically insert the worksheet name into a cell when it is renamed. For example, in the attached file I would like the worksheet name to appear as a title running up the side of the page (shown in yellow) whenever the worksheet is renamed.

Hope I expressed my needs well enough.

Thanks in advance,

Sparky0303

[hotpepper]

Try this formula:

=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

[sparky0303]

Thank you so much. I never would have been able to figure that one out at the experience level that I am at. It works perfectly. Thank you, thank you, Thank you!