Using SumIf from multiple tabs

[AnnaG87]

Hi there,

I'm trying to create a summary tab for the attached spreadsheet that adds up all of the columns B, C, D, from the three green tabs, but based on the subtotalled shaded cells.

Is this possible to pull from multiple tabs? If not, does anyone have any suggestions as to how to complete this?

Thanks for the help. Always appreciated!
Anna