Duplicating a cell from one worksheet to another worksheet

[Stormy4757]

How do i get a cell to automatically update another cell in another worksheet when I updates its contents? I have a huge spreadsheet of classes, and at times, the name of a particular class will change. I have the titles of these classes on a few other worksheets in the same document that I would like to automatically update when I make this change instead of me going in to each worksheet and doing it manually. Is there a way to do this?

Thank you in advance for your help!

 

[XLPadawan]

Choose a cell and type = (an equal sign)
Select the tab (worksheet) with the value you want to match and click the cell containing that value.
Press the Enter key, then the up arrow key.
Look in the formula bar and you should see the name of a tab (e.g. Sheet2) followed by an exclamation mark (!) and a cell reference. For example, =Sheet2!A3