Generate Multiple PDF's with the available data in different sheet

[VinodKrishnappa]

Hi, I've situation like this.

In "Data" sheet i'll have data like below list

Emp. No	Name	Category	Amount
12236	ABCD	Telephone	$2100
12243	EFGH	Medical	$4200
12256	IJKL	Telephone	$1566

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

The above data should come in the following format in different .pdf for each employee based on emp. no. wise. The format will be in next sheet as sheet name "Format", which contains vlookup formula based on emp. no.

Employee No.	12243
Employee Name	EFGH
Medical	$4,200
Telephone	$0
LTA	%0
Total	$4,200

<colgroup><col><col></colgroup><tbody>
</tbody>

Amount in Words Four Thousand Two Hundred


The data will be for more than 400 emp. i need to provide individual pdf to individual emp. based on the emp. no. Please help on this.