Hello all,

I hope everyone is well and safe.

I just joined this forum as I need to merge data from multiple files into a single file for work ASAP. I understand that there is the mail merge function but the out of the box function does not read from multiple files. I did see a thread on this forum where INCLUDETEXT was suggested. I tried it but mustn't have used it correctly. I think I will need basic instructions as I am not a proficient at writing scripts.

In a nutshell, I have multiple Excel files with each containing a table with the same column headings.

I would like to consolidate, or merge, them into a "master" Excel file under the same column headings. Ideally the master file is in Excel, if not, one big table in Word document will do.

I'd like to have the consolidated table sorted by one of the columns after all the data has been copied across.



row 1 Column A, B, C, D from file 1
row 2 Column A, B, C, D from file 1
row 1 Column A, B, C, D from file 2
row 2 Column A, B, C, D from file 2
...
sort by column B

Thank you in advance.

Regards,
Lisa