maintaining a list on a new tab based on multiple criteria

[jangell]

For my little league program I have multiple tabs set up in an excel sheet (attached)

I would like to maintain one master tab and have that master tab populate all of the other tabs based on a set of criteria (but only if ALL criteria are met)

So on the master tab i would like to have a list of names, age groups and whether or not they have confirmed the invite.

If they are of a certain age, are rostered on a certain team and have accepted the invite I would like to return a list of those kids on a specific tab (tab correlates to the age group)

Example - if column A on the Master sheet has a 7 or an 8 AND Column B has a D in it AND E has a y in it

The 8 tab would have a of all kids that met the above criteria.

Any help would be great.

[jangell]

I have attached a rough example of the data