Attaching the actual file is easy. Click inside the cell of the spreadsheet where you want to insert the object. Select the Insert tab. Click Object in the Text group to open the Object dialog box.

Open the First Spreadsheet; Open Excel, and then open the first of the spreadsheets to be merged. The spreadsheet can be in the same workbook or in a different workbook file.

By default, Excel names each new spreadsheet you add as Sheet1, Sheet2, Sheet3, and so on. If you plan to use many sheets or want an easy way to distinguish between them, you can give a sheet its ...