Hi,

As has been suggested the CELL function will give you the information.

But if you want the sheet name of each individual sheet remember to
include a cell reference in the CELL function otherwise all sheets will
display the same information, which will at least be correct for 1 of
the sheets :)

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

Cheers
Andy

ckane wrote:
I have a worksheet with several tabs. Each tab is a different persons name.
Is there a way to have the name on the tab automatically show up in a
specific cell on the worksheet. Thank you!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info