How to link data from a column on one tab to a column on another tab?

mtarler Thank you for the reply. Yes, this file gets updated each month for a year or two. Currently we manually update the previous funding column to continually add to that total and then zero out the current column to prepare for the new numbers to be input. It just feels risky to have such human error possibilities. Years ago, I worked with this type of spreadsheet but was able to click a button to create a new month. Excel moved all figures appropriately and I was able to simply 'save as' for my new month and enter in current info. I'm trying to recreate the magic. I'm able to have a macro state that my previous column will equal my current column which is lovely until I zero out my current column and then of course the previous column follows suit. I'm able to have my previous column equal the actual numbers of my current column and then zero out current. But I am unable to figure out how to have my current column numbers get added to the previous column each time I click the button to start a new month. Your idea of an additional tab might be my best bet at this point. Oh! Then, perhaps I could create a column that always pulls from the totals on my other tab. It's still manual entry but it does feel more secured than the current procedure