How to print multiple sheets from data on another sheet

[PuntingJawa]

I am trying to figure out how to create a template that will print multiple sheets at once. I can print one at a time right now by filling in information on one sheet and printing from the other but I want to add all information at once and have it print at the same time.

Below this is where I input information on sheet 1. I would need to moved some things to their own columns to do this in bulk but this is what I came up with on the fly.

R211 OP CRATE PRINT.xlsx
	A	B	C	D	E
1	Crate #	Operator LH	Hanger LH	Operator RH	Hanger RH
2	0
3
4
5
6	DATA
7
8	CRATE#	INPUT HERE
9			OPERATOR LH
10
11
12
13			HANGER LH
14
15
16
17			OPERATOR RH
18
19
20
21			HANGER RH
22
23
24
CRATE PRINT INPUT

Cell Formulas
Range	Formula
A2	A2	=A9
B2:B5	B2	=IF(B9<=0,"","DOL"&B9)
C2:C5	C2	=IF(B13<=0,"","DHL"&B13)
D2:D5	D2	=IF(B17<=0,"","DOR"&B17)
E2:E5	E2	=IF(B21<=0,"","DHR"&B21)
B6:E6	B6	=IF(B2<="","",B2&", "&B3&", "&B4&", "&B5)

After I place the information required into cells A9 and B9:B24 the data is formatted for what it needs to look like on the template. As I mentioned earlier, I have managed to get this for 1 at a time. I'm just not sure how, if I place a string of say, 40 lines, for this to print out with 4 cells at a time, to print 10 pages.

R211 OP CRATE PRINT.xlsx
	A	B	C	D	E	F	G	H	I	J
1	CRATE # HERE
2
3	PROJECT			Shipping Date						Vendor Packing Slip#
4				Arrival Date (ETA)						P/S NUMBER
5	DELIVERY TO
6				Vendor Work Order #:
7
8
9
10
11	SHIPPED FROM
12
13										Freight/Carrier Tracking #
14
15
16
17	LINE #	THEIR P/N	DESCRIPTION	OUR P/N	Serial Number	QTY	Qty			REMARKS
18					(If applicable)	Shipped Now	Ordered	Previously Shipped	Balance after this shipment
19	LINE NUMBER	PART NUMBER	DESCRIPTION	OUR NUMBER HERE	ITEM SERIAL HERE	0	0
20						0	0
21						0	0
22						0	0
DOOR CRATE PRINT

Cell Formulas
Range	Formula
F19	F19	=COUNTIF('CRATE PRINT INPUT'!B2:B5,"?*")
G19:G22	G19	='CRATE PRINT INPUT'!G9
F20	F20	=COUNTIF('CRATE PRINT INPUT'!C2:C5,"?*")
F21	F21	=COUNTIF('CRATE PRINT INPUT'!D2:D5,"?*")
F22	F22	=COUNTIF('CRATE PRINT INPUT'!E2:E5,"?*")