Collating data in several columns

Ok, have attached an example similar to the type of thing I need to work with.

For me the difficulty is all about getting the list of team names that appear in all quarters so I can use a Vlookup on them to get the information to compare teams by quarter and put a zero in if there was no value returned. The latter part I can do, its just finding the easiest (quickest) way of getting the names.

Hope you can help, and hope the example makes sense.

Oh and I have Excel 2007 at home, but unfortunately on Excel 2003 in work, so if the solution is practical to work with 2003 I would be grateful.

Thanks.

PS. I know that once I have copypasted all team names from all quarters being referenced into one column the pivot table function will summarise them into a nice list, would prefer to just be able to select the table and get this information.