1. Open the EXCEL table, create a summary table, and then click Data-Consolidated Calculation on the ribbon. Pop up the consolidation calculation window, click the arrow icon on the right side of the reference position, and select the detailed data to be consolidated.

2. First, open an Excel document, as shown in the figure below. Then click the data, as shown in the figure below. Then click New Query, as shown in the figure below. Then click from file, as shown in the figure below. Then click From Workbook, as shown in the figure below.

3. If it is an Excel table with the same format, you can use VBA to quickly summarize all the data in several worksheets into one worksheet.

4. You need to click the Summary workbook and select a cell as the starting position of the new table. First, select data in Toolbar-Consolidation Calculation. Then in the dialog box, click the small icon to the right of the reference position. After clicking the small icon, select the data. Then continue to click on the small icon, and you will return to the previous interface.

5. You need to put multiple excel tables in the same folder and create a new excel in this folder. As shown in the figure: Open the newly created excel table with microsoftexcel, right-click sheet 1, find "View Code", and click Enter. After entering, you will see the macro calculation interface.