Make A1 display name of worksheet

[Tyr@work]

I'm a bit of a newb at Excel functions, and if this is a stupid question, I apologize.

I'm working on a project, and I need a cell on a worksheet to produce the name of the worksheet, such that if the worksheet changes, or is copied [Sheet1 renamed to Sheet(1), for example] the cell will automatically update [now displaying Sheet(1) in cell A1].

I cannot use VBA or Macros in this solution, due to security setting restrictions.

Help?

[ncmay]

Try the website below:

http://www.ozgrid.com/Excel/variable...heet-names.htm

[Tyr@work]

Perfect. Thank you!