How to retrieve data from another workbook into specific sheets

So I have a huge sheet with some NHL statistics.
The way I have it set up right now is quite convenient because I can filter out whatever I need, then copy the info to a scratch sheet and sort/manipulate from there.

But, I was curious about setting up another workbook which would contain 30 sheets in it. One for each team in the league.

What I want to do is set up each sheet so that it pulls off every game in my Master sheet for a given team.
For instance, in the TORONTO sheet, it would pull, from the master sheet in the main workbook, all the games where TORONTO is listed as the Away team, and all the games where Toronto is listed as the Home team.
It would find those rows where Toronto was playing and paste the entire row of data into the TORONTO Sheet, which would then be sorted by date.

Without getting into too much detail, the columns that indicate TORONTO is playing would be Column R and Column U. The date is Column A (I guess I would just set up some kind of macro to sort by date once the rows are pasted to the TOronto sheet?)

I just want to know:
A) Is this possible
B) How I would go about doing this?

.. I don't necessarily need a step by step walkthrough, but maybe just someone to point me in the right direction and possibly some of the key functions I would need... I'm guessing I would need to use Index/Match for this?

Any help would be appreciated...
As for sending a sample, my main workbook contains about 22 sheets, and the main data sheet (called "Summary") contains 59 columns and will eventually have about 1300 rows.

So basically wherever "Toronto" shows up on the 'Summary' sheet, I want that ENTIRE row pasted into another workbook, into the "Toronto" sheet... the same goes with the other 29 teams..

Thanks

I've never used a pivot table before, but just tonight saw a vid on it and thought i'd give it a try..
But with 52 columns, it gets a bit messy, and if there's any conceivable way i can avoid them, I will

So how would I set it up? I'm as familiar with PivotTables as I am with Chinese.

Problem with the Pivot is that i want ALL 52 columns available.

Could I not just create a dropdown list with all 30 teams in it, and create an Index/Match which will retrieve all the rows with that particular team in it?
Or would this just grab the first row with that team in it?

At least with the Index/Match, I wouldn't need a separate sheet for each team.