Need help in Macros!

[sinfulloyolite]

I have a list of employees reimbursement amount payroll wise.
I need those to be populated into reimbursement form which is in excel template.
I would like to populate data from master list into reimbursement template (It will be one liner item to be populated as Allowance)
I can link first sheet with appropriate cells to make sure I have all needed values into the first form. (For your reference)
I want the further rows from master data to be copied similarly into multiple workbooks and have them renamed based on Employee name in the form and Payroll Date (DDMMM) cell A10.
I have attached images of my content

Any help would be greatly appreciated!

 

[Fluff]

Duplicate Populating Data into different workbook based on on Template from Master Data

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).