This is technically merging an Excel document with a Word document , not merging two Excel files.
Consolidate creates static results. If the source documents change, the master does not update. excel merge documents
For advanced users who need to merge documents daily without opening Excel, a VBA macro is the answer. This is technically merging an Excel document with