Numbers Mac: Automate filtering and copying by percentage

hi I am very new to Numbers ( 13.1 ) on a Mac book , I have football database a sheet for each league, each sheet has 16 columns by 24 rows what I am trying to do is get a value of a greater percentage in a column, then carry on to the the bottom of that row until all with the greater percentage are found, then copy all rows selected to another sheet. At present I do this manually but struggling to find the best way to automate it. if somebody could point me in the right direction please.