Excell multi sheet formula

I have a budgeting spreadsheet that tracks cost coded spending. Each page of the worksheet covers two weeks of cash flows.

I want to add the costcode of multiple worksheets and show it in one cell on a ‘totals’ page.