Hi Lucy,

That consolidate tool you're referring to is for data that's of the same type and in the same format on multiple sheets. e.g. multiple sheets containing the actuals, not one sheet of actuals and one sheet of budget data.

I recommend you use Power Query to consolidate your data as I showed you. You have Power Query on the Data tab of the ribbon in Excel 2016. You can learn Power Query here.

Mynda