Excel spreadsheet

Hello Veera

Thank you for your question and welcome to the forum.

The Consolidate feature in Excel allows you to summarise data from different worksheets together.

To consolidate data:
1. Select a cell that will represent the top left corner of the data, when the consolidation is completed.
2. Click on the first sheet that contains data you would like to include in the consolidation/summary.
3. Click under Reference, and drag over the data to include in the consolidation, including data headings.
4. Click Add.
5. Repeat steps 3 and 4, gathering data from different sheets.
6. Tick the Use Labels in Top Row and Left Column options.
7. If you would like the consolidated/summary data to be linked to the data you have selected from each worksheet (i.e. the summary to be updated) then tick the Create Links to Source Data box as well.
8. Click OK. The consolidated/summarised data should appear on the worksheet that you had selected the cell on in step 1.

I hope this helps.
Amanda

Kind regards
Amanda