Consolidating multiple pdf files into one
On the Data tab, in the Data Tools group, click Consolidate. For example, cell B2 (in distric1.xlsx) cell B2 (in district2.xlsx) cell B2 (in district3.xlsx). Note: if you don't check Top row and Left column, Excel sums all cells that have the same position.At the same time, a small piece of macro code will do the trick to merge excel files for you even though you are not a programmer.All you need to know is how to paste the VBA code and run it. Now, please check the same whether the code is working perfectly or not. It looks like below and there is no data resides in the book except the header.
One of those actions is the ability to create PDFs from the selection.You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet. If you check Create links to source data, Excel creates a link to your source data (your consolidated data will be updated if your source data changes) and creates an outline.