Printing PDFs file with Excel Sheets With Page Numbers

Hi Folks,

I am trying to build a system for my department by using an excel macro. This excel file will have 3 sheets first two sheets will have my process data, and third sheet in "A" column which contains a list of pdf file names along with their paths. What I want to achieve is, when I run this macro it should print my two sheets, after which it should print pdf files one by one. The most important is, we want to see the page numbers at the bottom in the format ("Page 1 of 13"). What we see as a challenge here is , printing the pdf files located in a particular path secondly assigning the page numbers even the pdf sheets.

It would be of great help for us if you could give us the solution.

Example file is also attached for your reference.