worksheet function - I want to map rows from Sheet one on and excel file to other sheets if they meet certain criteria

I work in sales and cover a large territory. To manage the territory, I break it up into "Zones" (i.e. Philly / Pittsburgh / etc). My organization provides an excel file with every company I call on and a litany of sales information - this is Sheet 1 of my excel workbook. I've already inserted an extra column on Sheet 1 and labeled "Zone" to identify where each company will fall into.

To simplify the management within each zone, I want separate Sheets for each of the named zones. What I'd like to know is what formula I can enter on the sheet labeled "Philly" such that "if" the Zone Column on Sheet 1 = "Philly", then the entire row will map to the sheet labeled Philly.

Further, some zones have sub-zones (i.e Central PA) and so I'd like one sheet to search for any Sheet 1 Zone equal to Harrisburg, State College, Scranton, etc and bring them all to the one sheet named Central PA in the same fashion as above.

Thanks for your help!