How to add multiple invoices in pdf format to a single excel file?

@Harshita_Ramesh ok so ignore vb Script.
I have got to look your solution but I am unable to read.
image