Multiple forms printing

[MarkDShark]

I created a worksheet where on the input screen as i enter info on it, it populates a form on another tab that im able to print out. The input screen updates with a sequence number when ever i've printed the form, upon clearing the sheet with a print button, the sequence changes, you know, from seq 1, seq 2, seq 3 etc. At the moment, once i enter my info, i have to print the form out to be able to continue to the next info to be input. What i need to know is there a way i can create a way to not have to print one at a time, but to print multiple forms in there sequence order? I would like to be able to input from the input screen, populate the form, then clear it and go to the next sheet to be input clear that then to the next one etc. Once i've felt i've reach enough to print out, like say 10, i can hit the print all button and all 10 sheets would print in order. I also would like to know if theres away to preview anyone of them at anytime. To recall them back up to see what i put on it. Once i've print, the list for those forms would clear and start with the next batch. Hopefully this can be done with excel. Thanks for your help in advance!

 

[Warship]

The short answer is yes to all your wishes.
A tall order however.

I would probably create a template sheet to use for printing.
At the end of input have a button that would copy the template for the upcoming form and clear the input form.

Keep a list of un-printed forms on either another helper sheet or even in a range name.
When desired hit your print button and print the sheets on this list.

As for recall, maybe a dropdown somewhere to choose the form, then re-populate the input form form what was already done.

As I said, you have a tall order, but all can be done.

 

[MarkDShark]

Well im not that tech with excel, so im not sure how to create what you've mentioned. I can do some stuff on excell, but again, not familiar with the process you mentioned.