Is there a way in Excel to merge two or more spreadsheets, either into one sheet with all the data on one page or with each sheet turned into a separate page?
Easy enough to do the latter.
Open both files (called “workbooks”) and in one, right click on the sheet tabs at the bottom of the window. Choose “Select All”. Then riight click again and choose “Move or Copy.”
In the dialog that appears, choose the other workbook from the dropdown list, and then pick the sheet in the other workbook that you want the first workbook to appear before in the sheet tabs at the bottom of the resulting merged document… or choose “to end.” Click OK, and there you go.
Save the merged workbook under a new name and you’re good to go.