Consolidate data

Hello Julia

Thank you for your question and welcome to the forum.

You can combine worksheets together to produce a summary of data using the Consolidate feature in Excel.

Go to Data - Consolidate.

Select the function you wish to use (normally Sum).

In the Reference box, select the data range you wish to include in the summary, including headings for the data, from one sheet. Then click Add.

Repeat the above until you have selected all the data ranges you wish to combine together.

Tick the Use labels in Top Row and First Column options; and tick the Create Links to Source Data box if you wish to have the summary update itself.

Click OK.

Kind regards
Amanda