Excel VBA to Merge Word Documents
 

I'm creating an internal report for a company, which can be composed of up to 8 separate sections (8 independent documents). Depending on the client, I want it to use sections X, Y, Z, etc. Each section is already in a separate word document (a basic template).

I have managed to correctly create a macro that copies the specific sections (separate documents) I want to a separate folder, and now I want to add a macro that all those documents into a new one, then saves it with a specific name, and creates a pdf.

The file names and paths are all listed in the spreadsheet already...

Any suggestions?

best,