SQL Query Wordpress

Hi, i need a question answering first to see if what i need can be achieved the simple way or alternatively i might need to look at a harder more complex way to achieve my goal. I am using wpdatatables plugin in Wordpress and i have created over a 300 tables and 1000 charts Currently i have a page set up for my first football team that shows all the statistics for the match and on every table i have created i have added to the sql query where team A = 'Football Team'. The problem i how have is that i need to create hundred of teams and they all need their own individual pages. The only way i can think of making this work is to duplicate the table but rename the team and import it back. That works but i am then left with the charts and have to manually change the chart ID on each page for over 1000 charts. this is not practical every time i need to add a team. Another way it would work is to use a single page for all teams and allow the user to filter the table for the team. This would work easily but it is not what i am after, i need individual pages for each team. So my question is this, if i was to use the single page senario i could copy the pages unlimited times but can a query be added to each of the tables so if a certain page is activated it will automatically filter data to that specific team/ Message me to let me know if it can be done with a price please Thanks Chris