I have a master spreadsheet that I use to track problems. Each problem
is given a reference. The first column/field in the master problem
spreadsheet is this reference number. There are also a number of other
columns that record data for but these are irrelevant to my question.
Currently when I create a new problem entry in the spreadsheet, I
assign a reference, create another spreadsheet from a template and
name it according to this problem reference. Further specific details
regarding this problem are tracked in this secondary spreadsheet.

My question is this. Is it possible to automate this? When I create
an entry in the master spreadsheet, after I insert the new reference
in the first field, it would be great if a vbscript could take a copy
of the template (template is in the same directory as the master
spreadsheet), name it according to the reference just given, and place
a link around the reference number in the first column of the master
spreadsheet that can then load up the secondary spreadsheet when
clicked. I just don't know where to start.