You need an additional software to merge Pdf files.
This software could be managed by VBA in Excel.
First have a look to PdfTk SERVER and run it manually.
Afterward we can see for a Shell command from VBA