Before I start some information on the spreadsheet I am asking for help on; it is used for Export Documentations, and there are a lot of different sheets needed.



So I have set up about 20 sheets in my work book, of which the first two are "data entry" sheets, and the rest are hidden. Once the user has filled in the only two viewable sheets this unhides some of the relevant sheets.

From this there are always
>> INVOICE (sheets named INVOICE01, INVOICE 02, INVOICE03......)
>> SHIPPING INSTRUCTIONS (only one sheet for this)
>> PACKING LIST (only one sheet for this)
>> COLLECTION NOTE (only one sheet for this)

Plus any extras like Customs Letter etc.



What I would like is to have a chain of commands so that when I press a created button, it saves the unhidden INVOICE / PACKING LIST as a PDF, then saves all visible sheets (minus the "data entry sheets") as a PDF, then prints all visible sheets as hard copies.

Any help is appreciated