Excel 2016 gives you a wide range of tools with which to format, summarize, and present your data.
To combine just a couple of sheets, you may not need anything else but the good old copy/paste.
A quick solution is to make a copy of one of the sheets and delete all irrelevant columns keeping only those you want to merge.
And then, run the Consolidate Worksheets Wizard, and select the option Copy data only for the matching columns in my first table in the list.
To ensure that every year’s workbook has a similar appearance, you can create a workbook with the characteristics you want, and save it as a pattern, or template, for similar workbooks you will create in the future.
A consequence of organizing your data into different workbooks and worksheets is that you need ways to manage, combine, and summarize data from more than one Excel document.
Today we will tackle a problem that many Excel users are struggling with daily - how to merge multiple Excel sheets into one without copying and pasting.