Aligw,

I've created the list of values, dates, and bill titles that could be used to populate a calendar or form a calendar. By this point I've tried several strategies. I believe excel could populate the calendar from my table. I've attempted x lookup, filter, and power pivot tables. I've attempted "get data from table" and direct cell references. I've also indicated what date of the month a bill applies in a separate table and attempted to connect the date to the calendar sheets with no success.
I cannot keep the values consistently on the correct date month to month. I'm not sure how to form a relationship between the dates and the titles rather than the actual cells.

So unfortunately, I cannot answer your question.