Consolidating worksheets in excel 2016
For example you have 100 worksheets of data and all the worksheets has the similar structure. I like to solve and automate any possible opportunity in Excel including in combination with Office Applications (Access, Outlook, Word, Power Point, Visio, etc) and other Non-Office Applications (SAP, IE, Batch, Configuration Management Tools, etc).
Whenever you link workbooks, you make it so that one workbook is dependent on the other.
You will then see the following dialogue box: Select a new source file, then click the Open button.