split tabs into different worksheet

hello everyone,

I have a budget file with 80 tabs. each tab contains a locational budget. each locational budget will roll up to an "area" budget, e.g. Los Angeles, San Diego, Orange county, Inland Empire...will roll up to Southern California tab. I would like to separate the tabs into "area" group. so, my file has the tabs below:
tab 1 Southern California - area
tab 2 Los Angeles
tab 3 San Diedgo
tab 4 Orange County
tab 5 Inland Empire
tab 6 King County
tab 7 Northern California -area
tab 8 San Franscisco
tab 9 San Jose
tab 10 Fremont
tab 11 San Ramon
tab 12 Sacramento
tab 13 Arizona - area
tab 14 Phoenix
tab 15 Tuscon
tab 16 Oregon - area
tab 17 Utah - area

I'd like to know if there is a way split each tab and group them by area. so I could send area budget to area manager.
really appreciate your input.

please have a nice weekend,

CY