When you insert files into an Excel ( file, such as a PDF file ... or share more comprehensive information when you send the spreadsheet to a co-worker. When you attach an object this way ...

Ideally, you should keep the consolidation process simple by opening all spreadsheets to be merged in the same workbook, or Excel file ... Click the "Add" button in the Consolidate Data wizard ...

With this enabled, the file saves automatically to OneDrive ... and rearranging the sheet tab order. By default, Excel names each new spreadsheet you add as Sheet1, Sheet2, Sheet3, and so on.