How To Merge Excel Sheets -

Use the tool if you need to merge data and perform a calculation at the same time, such as summing up sales from different regions. Combine data from multiple sheets - Microsoft Support

Click the double-arrow icon in the "Content" column to expand and combine your tables. how to merge excel sheets