You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet.
Learn how to use the Consolidate function in Excel to combine data from multiple worksheets. This step-by-step guide covers examples, tips, and best practices for efficient data consolidation.
Using the Consolidate tool, you can combine and summarize data from multiple files or sheets. This wikiHow teaches you how to consolidate data from different files or worksheets in Excel.