What is the best way to pull and seperate data from a table? VLOOKUP? Anything better?

I have a table that shows a sports league's schedule and results. I want to pull data from that table for each team and then separate it between home and away for each team on separate sheets. What w...