VBA script to pull data from one spreadsheet to create multiple

[Chasedward]

Hi, I have a basic excel template that must be completed for each project by looking up a master spreadsheet and for each project I need to complete each cell (about 6) with information from master spreadsheet and save each file as the name of the address.

Fields I need to pull from other spreadsheet

postcode
Reference
Eastings
Northibgs
Info

Sorry if this is not very clear. I am new to all of this.
Thanks. Dawn