Batch exporting of dynamic page to PDF

I'm looking in ways of making PDFs of a single page of Excel, whose content changes dynamically depending on a variable. I can't imagine I'm the first looking for this, but I couldn't find any information...

More concretely, let's say I have a huge table where I put in details of an order of a client (personal information, what he has ordered, how many, costs, etc.). On a different page I have a nicely formatted invoice, which I want to export to a PDF to send to the client. I just fill in the InvoiceID and the whole page is ready for export.

However, let's say I need to do this weekly for hundreds of invoices. This means that I need to start with InvoiceID_000, export to PDF, change the corresponding cell to InvoiceID_001, export to PDF, change the cell InvoiceID_002, export to PDF, etc. A lot of work. So I'd need something that can loop through all InvoiceIDs and export the page per InvoiceID.

I'd say something like:

Please Login or Register  to view this content.

Is this doable? Can someone guide me in the right direction? I have no experience with VBA, but I'm sufficiently experienced with mathematical programming and the "normal" Excel functions. Thanks!

Sorry for the late response, it took a while for me to test it in Windows. It doesn't work on the Mac, but perfectly on Windows! Thanks for making an entire working script!

Excel on Mac says

Please Login or Register  to view this content.

and then, in an additional message box

Please Login or Register  to view this content.

If there is a suggestion what the problem might be, that would be great and very practical for me.