Access 2003

Hello Toby

Thank you for your question.

To use Consolidate:

1. Select the sheet you want to create the summary/consolidation of data on, and select the cell that will represent the starting point for the summary when it appears.

2. Go to Data - Consolidate.

3. Use the Reference box to select the cells (including any headings) from each sheet you want to include in the summary, clicking the Add button once you have selected a range from each sheet.

4. Check the All Reference box, to see if you have selected all the cell ranges you wish to include in the summary.

5. Tick the check boxes to use labels from top row and left column. Tick the Create links to source data option if you want the summary figures to update.

6. Click OK.

I hope this helps.
Amanda