Displaying "Tab" name in a file

[TMich]

Is there a formula that returns the name of the worksheet
in a cell?

For example, =cell("filename") returns the file name in
the cell, so I hoped that something like =cell("tab")
would return the name of worksheet in the cell (It
doesn't..).

Anyone know? Thanks in advance.

 

[Ken Wright]

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)