“In this video you can consolidate data from same/multiple worksheets into one in MS Excel 2013.
The Data Consolidation tool makes it simple to combine worksheets, and even workbooks, in Excel and perform a function if required.
showing you simple step by step way how you can create Consolidate in MS Excel with following steps:
Step 1: Open all files (workbooks) that contain the data you want to consolidate.
Step 2: Ensure the data is organized in the same way .
Step 3: On the Data ribbons, select Data Tools and then Consolidate.
Step 4: Select the method of consolidation .
Step 5: Select the data, including the labels, and click Add
Step 6: Repeat step 5 for each worksheet or workbook that contains the data you need included
Step 7: Check boxes “top row”, “left column”, and “create links to data source” and click the OK button.”