See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

"Steve" wrote in message
...
Is there a way in excel 2000 to make a cell automatically change based on
the
worksheet name tab?

Thanks,
Steve