Create new sheet based on a template

I thought that this would be a fairly simple spreadsheet, however my boss has added a few bits which frankly have left me baffled. Essentially I have a master template with colimns running from A to Q. Most of what she wanted is fairly simple 'if' statements, however she also wants to move the contents of one cell to an adjacent sell based on the number exceeding a certain value, thanks to some help from someone on another forum that code works a treat.

Please Login or Register  to view this content.

My problems start when I want to create a new sheet/tab and let her name it. I would have simply created 12 months for her, unfortunately there is a sheet for a number of people and the start of the year can vary. My simple solution was to create a macro that copies the original Template (effectively sheet 1) and puts it into the newly created tab. However this does not copy the above VBA code across

Please Login or Register  to view this content.

In all fairness every time I read myself what I want I get confused, but any help on this would really be appreciated

Thanks in advance

Paul