Using the actual cells I'm working with as an example,

Sheet 1: Dashboard
Sheet 2: Finances

Dashboard sheet: M3="Total Cash on Hand" ; M4 targets what's currently in Finances!B40

Finances Sheet: B40 contains the most up-to-date calculation of cash on hand for this current period. Next period, I'll add the newest update to cell B41. The period after that it will be in B42, and so on, so I'm maintaining history.

Right now what I've been doing is just modifying the calculation in Dashboard!M4 to reflect [=Finances!b40], updating it to [=Finances!B41], [=Finances!B42], etc., for each new period. If there's any way to automate this it would make life much easier since I have about 12 of these categories that I manually update. They're simple to update manually, but it would save a ton of time given the work needed to do on the Finances page alone prior to dashboard update.

Does that make sense?