Consolidate feature

Hello Shiraz

Thank you for your question and welcome to the forum.

The purpose of using Consolidate is to summarise information from several different sheets into one sheet, where each of the sheets you are including in the consolidation share common headings.

To use Consolidate:
1. Select the cell that is going to be the starting point (top left corner) of the consolidated data.
2. Go to Data - Consolidate.
3. Under Reference, select the range of data from the first sheet to be included in the consolidated data.
4. Click Add to transfer the selected cell range from the Reference area into the All References area.
5. Repeat steps 3 and 4 until you have selected all the areas that you want to include in the consolidation.
6. Tick the Use labels in top row and left column boxes - this will then use the headings from each of the ranges you have selected from each sheet in the summary.
7. Tick the Create links to source data box if the summary needs to be updated when changes are made to the sheets you have selected data from in steps 3 and 4.
8. Click OK.

I hope this helps.
Amanda

Kind regards
Amanda