Hi everyone, I was kindly assisted yesterday with a problem I had. But soon realised that I am facing another problem. I have a workbook that contains the exact same spreadsheet with the only difference being that every new sheet having unique fiscal data for every new year. The formulas are refering to the previous year's data (on the worksheet to the right) to do calcs. But if I want to add a new worksheet for the new year, all the formulas are referring to the old fiscal years data. Would it mean I will have to manually change every formula on every new sheet to point to the right (previous year) worksheet?

I have attached the workbook fyi, the column with the problem is "SPLY". Is there a way to workaround this please anybody?

Budget1213_2.xlsx