If you have Automatic calculation set (usually the default) and you have
formulae in those other worksheets which depend on values in the master
sheet, then they will be updated automatically if you change a value in the
master sheet.

In those subsidiary sheets, you might have a formula like this:

=master!A1 * 20%

which will give you 20% of whatever is in cell A1 of the master sheet.

The syntax for these linked formulae is:

'sheet name'!cell_reference

Apostrophes are required if your sheet names have spaces in them.

Hope this helps.

Pete


"J James" wrote in message
...
I have a workbook that contains multiple worksheets, one of the sheets is
the
master sheet and I would like to know if anyone knows how you can set it
up
so that when you make changes in the master sheet, the other worksheets
will
automatically be updated? Haven't been able to figure it out. Any help
would be much appreciated.
--
J James