Consolidation of worksheets in a workbook | Excel forum

Hi Nerissa

thank you for your enquiry. In the workbook you would like to consolidate switch to a blank sheet (to give yourself some room for the consolidation results).

From the Data menu choose Consolidate.

You will find you can switch to other sheets in your workbook and the consolidate dialogue box will remain on the screen. Select the cells you wish to consolidate (including labels) and use the Add button to add their range to the dialogue box.

Repeat for data on remaining sheets.

In the dialogue box select "Use labels in". Excel will take you to the blank sheet you started on, then click OK.

The consolidated data is inserted into the sheet.

I hope this helps - do let us know if you have any further questions.

Kind regards,

Andrew