Pivot Table is a great tool to split a file into multiple worksheets
Presentation of the tutorial
If you are reading this article it's because you have a huge table and your have to split the contain in many worksheets.
Then we focus on the top of our pivot table and we will drop the item State.
Now we will create as many worksheets as there are State in our document. Select in the Pivot Table Tools menu, the Options tab menu and then the sub-menu PivotTable, and finally, the Options sub-sub-menu.
And there's magic! Excel automatically creates a page for each state.
Important note: you must filter your page or on (All) to forget the creation of any spreadsheet