I have created a "budgeting" sheet that Im using to track my personal monthly budget. I have many names cell such as DatePd, DateDue, AmoutPaid etc for each bill payer. These names are used in my calculations as well as used in my conditional formatting.

The issue Im having is that when I select the sheet and move/copy the sheet it copies the sheet and names but it doesnt appear to update them in the sheet. Therefore if currently have a Jan 2011 sheet, I want to copy this MINUS any values to a Feb 2011 sheet. When I copy it I want the names to take those of the Feb 2011 sheet to use in the calculations and conditional formatting.

How can I accomplish this? Im hope I made sense in what Im trying to accomplish :-)