how can you consoliated information

[Exxcel Noob]

hi everyone, i included a workbook full of nba team stats.

my question is how can i add all the player statistic into a table so i can look them up easier?

i hided all the nba team, so the workbook don't get crowed. i have 30 teams in my workbook. ty guy

[Exxcel Noob]

also, i would like when ever i opened the file the information will always be update. ty everyone