is it possible to reference a tab name within a cell by formula?

[Emma_D]

I know I can show the tab name in the footer on a document when I print it,
but is there anyway of showing what the tab name is within the worksheet
itself on the screen?

 

[dhstein]

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