i have two files one cash deposits and the other bank stmt.
bank stmt cell c4 is linked to cell d31 (always d31 cell on each tab(sheet) on cash deposit.

cash deposit has 12 tabs (sheets) representing each one a month of the year.
how can I have the cell c4 on the bank stmt file to update to the next month total automatically?

thank you.