On the Summary sheet we display the balance from each of the other sheets. If you followed the example above, the balance for each account will be in cell F3 in each sheet.

There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. We will look at the mouse method first.