Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.

What is the use of Consolidate function?

The Consolidate Function[1] in Excel allows an analyst to combine information from multiple workbooks into one place. The Excel consolidate function lets you select data from its various locations and creates a table to summarize the information for you.

What are the functions in the Consolidate dialog box?

In the Consolidate dialog box, you can select the cells you want to consolidate; or, if you named the ranges, you can enter the range names. You can choose various functions, such as Sum, Average, or Count, just to name a few.