I have a Workbook with several (16) sheets in it. I want the name of sheet 2
to reflect the info I have typed into cell B3 in sheet 1; sheet 3 to reflect
cell C3 in sheet 1, sheet 4 to reflect D3, etc. If I change the data in B3,
I want Sheet 2 to rename itself.

(Also, I use Excel 2000 - if that makes a difference)

I saw a question earlier that I thought answered this but can't figure out
how to do it. I don't know anything about macros or VBA so maybe I'm just
doing it wrong and not changing the right data in the formula. Please
explain in detail what formula I need, where to put it, and what data in the
formula I need to change to suit my individual project.

Thank you very much for any assistance I can get.