Is there an Excel formula that will separate data into multiple tabs?

Here’s my problem. I have a very large Excel document and I need to put all of the rows for each different office into its own tab. The problem is that there will then be 62 tabs. I don’t really want to have to copy and paste manually. Is there a way (a formula or some sort of filter) to tell Excel to move everything with a certain criteria in a certain column to a new tab?

Thanks!