Create a new worksheet labeled Combined to house the data from the other worksheets, as illustrated in Figure 1. Click on the Data menu. Click on From Other Sources and then select From Microsoft Query from the drop-down. Consolidate data in multiple worksheets - How to consolidate If you haven't already, set up the data in each constituent sheet by doing the following... In the master worksheet, click the upper-left cell of the area where you want... Click Data>Consolidate (in the Data Tools group). In the ... Feb 19, 2018 · How to Combine Two or More Excel Spreadsheets By Andrew Braun – Posted on Feb 19, 2018 Jan 1, 2020 in Software Hacks Microsoft Excel is a great application for you to keep your data organized and working for you, but all those numbers can sometimes get unwieldy when scattered over too many spreadsheets.

Feb 19, 2018 · How to Combine Two or More Excel Spreadsheets By Andrew Braun – Posted on Feb 19, 2018 Jan 1, 2020 in Software Hacks Microsoft Excel is a great application for you to keep your data organized and working for you, but all those numbers can sometimes get unwieldy when scattered over too many spreadsheets.