Is it possible?

[pepperjack]

Is it possible to change one the sheet's name and as a result have
cell's content change accordinly?

Example:

[image: http://home.comcast.net/~vixius2004/tutorial/question.jpg]

If so how?

Thank you very much;

 

[Tom Ogilvy]

See the formulas at the bottom of this page. They won't work unless the
workbook has been saved at least one time.

http://www.cpearson.com/excel/excelF.htm

 

[pepperjack]

You're an animal Tom... You're an animal.

Right ON! Thank you Tom.