The ability to link worksheets together is a vital skill for developing
solutions to complex problems using MS Excel.
Linking is very easy to do.
What linking achieves is that changing figures on
one worksheet makes automatic changes to another worksheet. This
is very useful when, for example, you are compiling a budget which
has information and calculations on many worksheets. In such a circumstance,
you will need a summary sheet that is linked to all other sheets.
If then a figure is changed on any worksheet, the summary will be