Create a Template drawing Values from Main Sheet

Hello Friends,

I am a Tax consultant in my office. So at the year end I need to give them a statutory form. To make this statutory form I have created a master sheet where all sorts of data is available. With that Data, I would like to create a statutory Form for every employee.

I have attached the master sheet (where all the data is available ) and the desired template (I want the output to be as in desired template).

Process:
When I a run a macro, I would like for a prompt for employee no; when I enter it, program searches for that number and creates a statutory form in (new workbook)- which has to be in the Desired Template format.

Once the statutory form is created, it should be saved with the "employee name" underscore "PAN no." in the same folder as the Master Sheet.

Please help.

Is this so hard.