Reducing the size of a spreadsheet - stopping a formula from calculating upon criteria

Hi, good morning everybody

I am hoping somebody might be able to help.

The problem I am having is that I have a workbook with a large number of tabs in which I am running sumifs across all of the tabs to get a total for a summary report. In the example attached there are up to 200 cost codes (on the cost code Tab) which can be entered - I currently only have 24 setup in the example. The issue I am having is that the team can use any cost code in any of the forecast Tabs (Labour / Plant / Subcon) which means when I do a sumif for the cost code on the report Tab, I need to run this across all of the tabs.

The issue I am having in my proper work book is that there are a lot more cost codes and a lot more Tabs to look in, so the size of the spreadsheet is considerably large.

The Question

Is there a way I can stop the sumifs running once it gets to cost code 25 in the report? I'm trying to reduce the calculation to only cells where there is a cost code, rather than running it for all the blanks. Obviously, I can just delete the calculation for myself, but getting others to update, reinstate the calc ect once they add a new cost code is not going to work well...
I am trying to only run the calculation in the cells highlighted in Green on the Report Tab and to stop calculating in the cells highlighted in Red.

Hopefully the attached helps to explain.

Many thanks in advance