Seeking macro (or other) to print multiple PDF files in order of list on excel sheet

[Task15]

I hope you can help me out with a simple solution to save me some time.

I regularly print off training manuals that connsist of up to 10 chapters totalling 50-100 pages, usually needing to print 50 or more copies of the entire document at a time.

Unfortunately, if I want to print off 50xChptr 1, 50xChptr 2 etc. I then have to count the pages and seperate the large stack of paper, keeping 50x folders open across several desks and it is generally a pretty poxy excercise. My photocopier/printer "Staggers" individual printing jobs making it easy to separate one job from another, but If I print 50 copies of a file at once it is regarded as one job, and does not get staggered by the printer. Pressing print 100 times is also not desireable.

Each chapter is a PDF file, and all chapters are in the one folder that does not currently contain any other files. The folder is on a shared drive. Merging the PDFs is not available as an option. Chapters are required to be seperated by cardboard tab pages that are not able to be passed through the printer.

In order to "trick" the system into seperating each chapter, I would like to be able to put a list of file names on an excel sheet, along with the number of copies desired for all files (N), and the address of the folder to be used. The macro (or some other mechanism) would print the file in the first cell, then the second, then the third running down the list untill it reaches a blank cell, at which point it would repeat the list 'N' number of times.

I have attached a mock-up of how I think the sheet would look. This is totally flexable and it doesn't have to look pretty.

Can you help?