Managing data that regularly updates

[MikeH93]

I've recently started sports blogging and I'm looking to do some statistical analysis. I've used a web scraper to record various statistics (Shots, passes, possession etc.) in all major league soccer games for the last 5 years. It looks something like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Home Team[/TD]
[TD]Away Team[/TD]
[TD]Home Possession[/TD]
[TD]Away Possession[/TD]
[/TR]
[TR]
[TD]Liverpool[/TD]
[TD]Barcelona[/TD]
[TD]55%[/TD]
[TD]45%[/TD]
[/TR]
[TR]
[TD]Arsenal[/TD]
[TD]Chelsea[/TD]
[TD]50%[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD]Liverpool[/TD]
[TD]45%[/TD]
[TD]55%[/TD]
[/TR]
[TR]
[TD]Barcelona[/TD]
[TD]Liverpool[/TD]
[TD]60%[/TD]
[TD]40%[/TD]
[/TR]
</tbody>[/TABLE]

There's roughly 500 teams in questions and I'd like to build a data base for each team. However I can't use to filter by home team because then I miss that teams away matches. I could filter by home matches and away and copy and paste but that would take a lot of maintenance since there are hundreds of matches every week. As a relatively inexperienced excel user, I am wondering if there is some macro that can read the one large spreadsheet of all matches (Like the one above but way bigger) and deliver just the matches of a certain team on a different sheet like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Liverpool[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Liverpool[/TD]
[TD]Barcelona[/TD]
[TD]55%[/TD]
[TD]45%[/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD]Liverpool[/TD]
[TD]45%[/TD]
[TD]55%[/TD]
[/TR]
[TR]
[TD]Barcelona[/TD]
[TD]Liverpool[/TD]
[TD]60%[/TD]
[TD]40%[/TD]
[/TR]
</tbody>[/TABLE]

Its quite an unusual situation so I haven't been able to find much related material through searches. Any idea what topics I should be looking into to build something like this? Also for anyone with SQL experience, I've been told that the kind of data I have is very suited to SQL instead of having 500 sheets floating around, would you agree?