Excel Combine Multiple Worksheets Into One Workbook - How to move & copy sheets (simplest method) the easiest method to merge excel spreadsheets is to copy one. Go the ‘from other sources’ option. In the function box, select the function that you want excel to use to consolidate the data. Web go to data > consolidate. In the get & transform data group, click on the ‘get data’ option. Web go to the data tab.
In the function box, select the function that you want excel to use to consolidate the data. In the get & transform data group, click on the ‘get data’ option. How to move & copy sheets (simplest method) the easiest method to merge excel spreadsheets is to copy one. Go the ‘from other sources’ option. Web go to the data tab. Web go to data > consolidate.