excel courses - Linking sheets

To add cells on different sheets you would use a formula like:

=A1+Sheet2!B1

Where "Sheet2" is the name of the worksheet
Separated with a ! from the cell reference

Simply create the formual like you normally would, but click on the relevant sheets and cells as you create the formula