Consolidating data from multiple sheets is a common task in Excel. You can use the dynamic VSTACK function for simple ranges or Power Query for more complex, automated workflows.
AI に任せるUsing the VSTACK function
In a new sheet, type =VSTACK(Sheet1!A2:D10, Sheet2!A2:D10) and press Enter to stack the ranges vertically.
Using Power Query (Get Data)
Go to the 'Data' tab, click 'Get Data' > 'From File' > 'From Excel Workbook', and select your current file.
Selecting and Combining
Select multiple sheets in the Navigator window, click 'Transform Data', and use the 'Append Queries' feature to combine them into one table.
=VSTACK(Sheet1!A2:D10, Sheet2!A2:D10)No, VSTACK is only available in Excel 365 and Excel 2021 or later.