Delete Unnecessary Data and Remove Blank Rows

Hello,

I am trying to see if there is an easier way for me to remove data across all worksheets instead of having to delete it manually from each sheet. I have attached a spreadsheet that I use as a template. What I would like to do and to reference my workbook is let's say that there were only 29 players that played this year. What I would like to do is keep the information for the 29 players that played but remove all data from Players 30 through 75 (as it shows in my template) and also delete the blank rows that come with this as well. I would also like to use this as well and change the condition based on the number of players that play in a particular season. I would appreciate any help with this.

Thanks in advance!