Automatic print for each page

[tharikcse]

Dear ,,

I have two sheets, one with name DATA and Other INVOICE, where i've Invoice format has 10 rows to print from the values from data has 99 rows,

DATA Sheet,

A	B	C	D	E	F	G
S.NO	CAT NO	ITEM NO	DESCRIPTION	UNIT	QTY	PRICE
1	882-124-001	126200005	PRODUCT 1	EACH <tbody> </tbody>	4485 <tbody> </tbody>	11.025 <tbody> </tbody>
2	545-454-545	126200454	PRODUCT 2	PACK	5458	12.025
....	...	...	...	...	...	...
...	...	...	...	...	...	...
99	454-445-454	126580025	PRODUCT 99	PK/12	5646	07.522

<tbody>
</tbody>

INVOICE SHEET - (A STANDARD FORMAT)

S.NO	ITEM NO	CAT NO	DESCRIPTION	UNIT	QTY	PRICE	TOTAL PRICE
1
2
3
4
5
6
7
8
9
10

<tbody>
</tbody>

Here, i want to print the invoice sheet for the values from DATA sheet, continuously for 99 products as 10 products per invoice sheet.

How can i do this, please help .

Awaiting in anticipation,

Thanks