I manage a series of schedules for my local baseball league and I am trying to setup some automated functions to make it easier for me and my successor. I need to do the following:

1) populate individual team worksheets with rows containing schedule info in order to create individual team schedules
2) list those schedules in date order
3) have no blank entries (continuous list)
4) adjacent cells with game total info need to populate with number of Home/Away/Total games and games vs. other teams
5) team worksheets need to populate automatically when changes are made on the master sheet
6) on master sheet I'd like to enter a team number code in the "Away" or "Home" column and have the team name automatically displayed.
7) on team worksheets I'd like the team name info to populate on a field easily displaying which team's game info is being shown

Thanks in advance for everyone's help!

2013 Pinto Schedule.xlsx