Take a look he

http://www.mcgimpsey.com/excel/formu..._function.html

In article ,
"Neil" wrote:

I would like to display the name of the sheet (the tab name) in a cell - or
vise versa. So the user could change it just once.