SUM on multiple dynamic criteria on a separate sheet in google sheets-CodePudding

I am attempting to write a formula that will sum values across multiple rows from a separate sheet based on multiple criteria. If it helps with context, the report will be a cashflow statement that sums up the different account types and displays them together on a dashboard. Here is a copy of the workbook I am using:

with some tweaking it could be written as:

=LAMBDA(x, SUM(FILTER(FILTER(OFFSET(x,,,9^9, 24), OFFSET(x, -1,,,24)*1=
 EOMONTH($F1, -1) 1), OFFSET(x,,-1, 9^9)=$A9)))(INDIRECT(B3&"!C10"))

or even arrayformula like:

=BYCOL(B3:F3, LAMBDA(y, LAMBDA(x, SUM(FILTER(FILTER(OFFSET(x,,,9^9, 24), OFFSET(x, -1,,,24)*1=
 EOMONTH($F1, -1) 1), OFFSET(x,,-1, 9^9)=$A9)))(INDIRECT(y&"!C10"))))