I am a basic excel user. I am looking to find an easier way to filter data. Currently I'm working with spreadsheets that have over 22,000 rows that need filtered by the 54 locations that we serve. The location name is one of the columns in the sheet, so I filter that column and copy the data in a new sheet. Then I repeat the process 53 times so that each location is in its own sheet. There must be an easier way to filter data from one sheet to another. Can anyone help?

Keith