Sumif Across Multiple Sheets

[Nagiino]

I have a summary page setup to sum the amounts based on a matching account and PC numbers. This works great, but I have to update the formulas each month when I add in the current months data. Each month has its own tab that isn't created until the month of. The monthly tabs will all follow a naming convention of MM.YY.

This is the formula I am currently using:

=SUMIFS('05.16'!$E:$E,'05.16'!$F:$F,'B&O Check'!D5,'05.16'!$A:$A,'B&O Check'!$A$5)

I want to be able to have this summary page update automatically when I change the date in cell C3, to pull data from the tab with a matching date in cell A3.

I also tried my hand at using indirects and a list of the tabs, however when I don't have tabs that don't exist yet added to the list, it causes a #ref in the formula and brings back a 0.

Here is the formula I'm using for that:

=IFERROR(SUMPRODUCT(SUMIFS(INDIRECT("'"&K5:K16&"'!$E:$E"),INDIRECT("'"&K5:K16&"'!$J:$J"),$C$3,INDIRECT("'"&K5:K16&"'!$F:$F"),D5,INDIRECT("'"&K5:K16&"'!$A:$A"),$A$5)),)

I know the fixes for these are very small manual steps, but the purpose is to have this setup someone one only needs to create the new monthly tabs each month, and the summary will fill itself out without anyone else having to fiddle with a formula.

Any help is appreciated!

[crushdrinker06]

As far as tabs go. If you are willing to have a final tab that is always last you could do something like =sum(Sheet1:SheetFinal!A1). In this way as long as the sheet they add is between those two sheets it will be summed.

[Nagiino]

I'm not opposed to having a final tab. However, I wasn't able to (and I believe I read somewhere that you can't) have a 3D reference in a Sumifs. I have to pull the data based on three criteria; column F, column A, and the date which is in A3. Can you provide an example of how yours would work?