Macro to Loop Print 1 Template multiple times

Hello; I have a model I've been working on that creates invoices for the same product but to multiple customers (the loop part) each month. I have three exhibit tabs that need to be printed. Two of then (say tab 2 and tab 3) just once (they are summaries) and the other (tab 1) needs to "loop" print once for each customer.

I'm hoping to create a macro that updates cell F12 in tab 1 with each customer's identification number, prints it, and moves to the next customer. I have all the customer's look-up information in tab 4, so I was hoping there to be a command prompt for the user to even print 1 customer's invoice by selecting from a drop-down box in the command prompt, or to "select all" to print.

I know enough VBA to be dangerous and edit other people's codes, but I haven't been able to find this scenario anywhere and wouldn't know where to begin if I were to start from scratch.

I appreciate anyone's willingness to take a stab at this. Thanks in advance for your help!

Hi Leith,

Let's say tab 4, cells A1:A20 - thanks!

Hello - the actual model I've compiled is too large to attach, so I've pared it down in the attachment. The highlighted cell (F12) in Exhibit - 065-066-067 is what needs to change for each customer and that exhibit is the one that needs to loop-print multiple times (if print all selected) or print once if one specific customer is chosen. Exhibit Composite Invoice is the second exhibit that needs to print (but only once) and includes the customer ID # look-up (column B); Finally exhibit - Boces II invoice also needs to print once.

There are other sheets in the actual model that will adjust the first exhibit depending on what is chosen in F12.

Thanks for your help!

Also, in between printing of each customer's exhibit it would need to run a macro I already have in it that hides/unhides unnecessary rows on the invoice... I forgot about that detail, let me know if you need more information on that though. Thanks!