Extrat data from master into 130 individual sheet

Dear all

Can you help me with a very time consuming task.

I have these data with peoples travel allowances, what I need to do is

Extract;
1. Name in ROW A
2. Personal Nr ROW B
3. Country ROW L
4. City Row K
5. Distance ROW D
6. Nr of persons > 2Years ROW C
7. Full Year ROW F
8. Total Payment ROW I

Into an individual sheet for all names so that they can receive it and view for themselves.

The individual sheet has a template where
Names should be placed at row A4
Country in A20
City in B20
Distance in C20
Standard travel allowance in D20
No.of persons > 2 year in E20
Full Year F20
Comments G20
Rappel H20
Total to Pay I20

I deleted the names as they are confidential but I need to send out 137 individual sheets taken from the master file

PLEASE PLEASE HELP

I think a macro would be best here to save a lot of time

Hi Evolta
Thank you for replying, do you know how to create one??? I am new into this but I would really like to save some time

If you don't know anything about it, then it might be smart to start learning the basics first.
I did something like this for defect reports, so I know its possible.

For specific questions you best ask here: http://www.excelforum.com/excel-programming-vba-macros/
If you wish to get help from the best (paid): http://www.excelforum.com/forumdisplay.php?f=171