Combine data from multiple sheets - Microsoft Support
To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet. The worksheets can be in the same workbook as the master worksheet or in other workbooks.
Applies To:
Excel for Microsoft 365 for Mac, Excel 2024 for Mac, Excel 2021 for Mac
Windows 8.1 support ended on January 10, 2023
However, after January 10, 2023, your computer running Windows 8.1 will no longer receive security updates. In addition, Microsoft customer service will no longer be available to provide Windows 8.1 technical support.