You can use the Before sheet: box to stipulate the order that the sheets are in.
Repeat this process with the rest of the sheets you want to merge. Sometimes, you might want to take more than one dataset and present it as a single sheet.
This is often useful for adding together sales data from multiple sources, combining entries from employee timesheets or consolidating data from survey responses.
Whatever the reason, you can merge data from one Excel spreadsheet to another using Excel's Consolidate Data wizard.
Select Sum from the dropdown and then use the button in the References field to access your spreadsheet so you can select the data you need.