Creating a master budget file from multiple project budgets

Per_GOAL

I am trying to create a master budget file for tracking budgets and spending across several sheets, but I am struggling to come up with a solution that would enable me to drag the cell references across, like you can do in excel where it dynamically changes the cell reference.

The sheets are structured with a budgetline description, Total Budget and then a monthly Actuals column for each month, that I would need to roll up into a master budget sheet.

is there a way to do this?

Paul Newcome

Have you looked into creating a report instead?