I am attempting to sum if the blank cells from another workbook across sheets 1 through 10 when column A:A (below) matches matches column F:F (other workbook) and row B:B (below) matches E17 (other file).

I could sumif one column at a time, and change the sheet reference manually, but there are about 75 columns, Any idea of a solution?

File
Workbook1.xlsx
Workbook1.xlsx
Workbook1.xlsx
Workbook1.xlsx
Workbook1.xlsx
Department
Department 1
Department 2
Department 3
Department 4
Department 5
Expense Type 1
Expense Type 2
Expense Type 2
Expense Type 4
Expense Type 5