Can Excel 2007 copy and add worksheets based on population a cell
 

I am trying to set up a global worksheet that would add a copy of a worksheet
that exists in my workbook when I populate a certain cell in the global
worksheet. Can excel do this and how?

example: my workbook contains 3 worksheets ( global,summary,template)
if for instance in the global worksheet
cell A1, A2, A3, A4 are blank for a user to fill in with info. so the user
would populate A1 & A2 with info. at this point I want Excel to copy the
Template worksheet and add 2 copys of the template worksheet because A1 & A2
have been populated. does this make sense? and is it possible?