exporting data from master file to template file (autopopulate a template)

Hi all,

I'm hoping someone can help me with some code to export from a database to a template which would be manageable to modify and expand on for an amateur level vba user.

I've attached 2 test files, one is the database master file containing the projects (each row represents a project, unique reference number in column A) and the other is the blank template file i'm hoping to export data into and then save down with the naming convention "column A_column B.xlsx"

Kept the test files simple but would need to modify any code to apply to much larger database consisting of many more fields etc.

Thanks
Neill