I'm not sure if what I have in mind is possible, but here goes.

I'm trying to create a kind of budget worksheet to track my expenses, my income, etc, on a monthly basis for my fiancee and I to use. Ideally, I would have a control tab where I have a list of steady incomes, steady expenses, and budgets for miscellaneous expenses. I'd like to have pie charts on this control tab as well for visualization of monthly progress. This all, I can do. Where I reach a problem is when I set up links from the monthly summary tabs I will create. Every tab will be calling to the same locations on the control tab. What I want to happen is when I reach the end of January, the January tab stops linking data from the Control tab, and saves the final January entry, automatically. Then the February tab would be actively calling. Does this make sense? I'm going to be building the file right now, so I'll have an example prepared sometime today, depending on my workload.

Thanks