this should help, i suppose i'd need to bring in a loop too 

master.Range("A" & Row) = template.Range("B1")  'Reference no.
master.Range("B" & Row) = template.Range("B2")  'Title
master.Range("C" & Row) = template.Range("B4")  'Confidentiality
master.Range("D" & Row) = template.Range("B3")  'Name
master.Range("E" & Row) = template.Range("B6")  'Department
master.Range("F" & Row) = template.Range("B8")  'Priority
master.Range("G" & Row) = template.Range("B7")  'Building
master.Range("H" & Row) = template.Range("B10") 'Current Stage
master.Range("I" & Row) = template.Range("C11") 'Stage 1
master.Range("J" & Row) = template.Range("C12") 'Stage 2
master.Range("K" & Row) = template.Range("C13") 'Stage 3
master.Range("L" & Row) = template.Range("C14") 'Stage 4
master.Range("M" & Row) = template.Range("B16") 'Value