Sumif Indirect Multiple Sheets and Another File

[jjramirez85]

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 <tbody> </tbody>	Workbook1.xlsx <tbody> </tbody>	Workbook1.xlsx <tbody> </tbody>	Workbook1.xlsx <tbody> </tbody>	Workbook1.xlsx <tbody> </tbody>
Department	Department 1 <tbody> </tbody>	Department 2 <tbody> </tbody>	Department 3 <tbody> </tbody>	Department 4 <tbody> </tbody>	Department 5 <tbody> </tbody>
Expense Type 1
Expense Type 2
Expense Type 2
Expense Type 4
Expense Type 5

<tbody>
</tbody>