Open Excel, and then open the first of the spreadsheets to be merged.The spreadsheet can be in the same workbook or in a different workbook file.If all of the spreadsheets use the same category headings, you can merge data by category name regardless of where the categories and data are located on the spreadsheets.
The data must be brought together in one report for getting the General idea. To the right and below of this cell should be free.When the original spreadsheet is updated, the merged spreadsheet is automatically updated, similar to an Excel Pivot Table.Randall Blackburn has worked for several Fortune 1000 companies as a technical writer over the past seven years.Whatever the reason, you can merge data from one Excel spreadsheet to another using Excel's Consolidate Data wizard.
If you have only a few spreadsheets to combine, and the column headers and orders are identical, you can also simply copy and paste the data into a master sheet, though the sheet won't automatically update if the others change.
Click the file, and then click “OK.” The file path is added to cell references for the merge.