Do you need year-to-date? What I do is just "save as" for each month and
start a new worksheet. Then the format remains the same and the entry will go
to the right place for your single month. So save march, then save as April
and relabel and input April info.

"Teo" wrote:

This is kind of complicated.

In one sheet we have a rolling income statement (Jan-Dec) in which we enter
the figures for the actual month manually (this is the input sheet).

In second spreadsheet we have a similar rolling, but with budgets figures.

The third sheet only refers to the current month and it reads from both of
the sheets above; we only want to show the current month figures here.

For example if the current month is March, we want the third sheet to read
the figures corresponding to March from sheet one and the figures
corresponding to March from sheet two for the budget.

When I open sheet one to enter April figures, I want to see the numbers in
sheet two and sheet three change to the corresponding April figures without
copying cells.

What will be good here?