2016

Merging Spreadsheets In Excel 2016. This will open the power query editor. On your excel ribbon, go to the ablebits tab > merge group, and click the combine sheets button:

Excel 2016 allows you to consolidate data from different worksheets into a single worksheet. Next, press home > format > move or copy sheet from the ribbon bar. Next, in the reference box, click the collapse button to shrink the panel and select the data in the worksheet.