Recurring Values on Specific Dates Across Worksheets

All,

I am an Excel novice, perhaps even less than a novice honestly, and I've been trying to figure this one out for a couple weeks now.

I have created a "budget calendar" to keep track of bills, their daily amounts, and their weekly amounts. I started my week on Thursdays- which is why I couldn't simply use a template. I have the months organized into their own separate sheets.

Everything is set up and ready for bills and values to be added (an example of this can be seen in cell H10 and I10 of the attached document).

My questions is this: How do I set up a bill due on the 1st of the month to recur for each of the following months, in their separate worksheets? Being that each month has the dates in different cell values per sheet, I cannot simply enter values and drag. I know that I can link February sheet to January sheet- March to Feb, etc. (so that each month takes into account any changes in bills based on the previous month) Is there an easier way to recur these values?

To show exactly what I am wanting to do, in January on cell H10 and I10 I manually entered "car" and "580"- I did the same on February in cell N10 and O10. This is what I want it to look like, but is there a way to formulate this so these names and values will populate on the day the bills are due (sample being due on the 1st) into the rest of the months on their own separate work sheet? Linking cells to one another per worksheet is incredibly tedious, and then if a due date changes... I'll have to do it all over again. Any ideas?



Attachment 832794