1) Your data is located in a sheet called "Database" with Column A being #, B being Player, C being HO, through column L being DT.
2) You are creating a summary sheet called "Summary" with Column A being Player name, and columns B:K being HO through DT.
In Column A of "Summary" make a list of all team names.
In B2, copy this formula:
Now copy across to column K for each team you have in your league.
If you also need to have a Games column, just add it (let's say column L) and put the following formula in cell L2: