Extracting and ordering data from a list

Hello,
I have built Excel charts of area high school football schedules for use in planning, etc., for my newspaper.
In the list (I have attached a single conference's entries), column B shows the visiting team (Opponent) and column D shows the home team (Host). The chart also includes date, location if not on school grounds, starting time and if it was non-conference.
Sometimes, a team (in this case an example could be Milton) will be the visiting team. Other times, they will be the home team.
I would like to set up something that could extract all the rows that include Milton's games (regardless of whether they were home or visitor) and stack them up on a new sheet, in order of date. Then I would like to do it for all the other schools, one at a time, so I have a bunch of worksheets (eight in this case, because there are eight schools in this conference). That way I could easily set the results up in text for use in that team's season preview, etc.

I have looked into Query and Filters and I don't think either one is correct. Building a macro would be beyond my abilities if I am supposed to search, select line, save, paste into new worksheet and repeat. I can't get it to work.

I would imagine there has to be a workable solution. Is there?

FYI, the "all games" sheet in the attached book contains all the games for the eight teams in this conference, stacked in chronological order. The "Milton games" sheet contains the eight games involving Milton, stacked in chronological order. When you take into account that our newspaper handles 16 conferences, you begin to understand why I am looking to automate this task.

Thank you.

hi, the Charting forum is really for questions around XL Charting etc (Pie, Bar etc) rather than Tables.... I'll ask a Mod to move this.

In short, assuming XL2007 per profile, I'd be inclined to do following - using your sample file

Formula:

Please Login or Register  to view this content.

the purpose of values in Col J is to negate repetitive calculations (isolating source rows)

you should also find you can clone the sheet, and if you change value in J1 the respective fixtures will populate accordingly.

Thread moved to appropriate section.