Macro to copy rows based on column criteria to a new sheets

I have a set of data that is based off states.

What I need is a macro to copy rows based on the state to a new sheet based on a group.

E.g. NY, PA, DE, NJ to copy to a sheet called "North East" GA,SC,FL to copy to a sheet called "South East" for example.

Things I ahve tried dont always seem to work - and starting to get fustrated!

So say I have

A B C D E
NY Data1 Data2 Data3 Data4 (This would copy to "North East")
FL Data1 Data2 Data3 Data4 (This would copy to "South East")
GA Data1 Data2 Data3 Data4 (This would copy to "South East")
PA Data1 Data2 Data3 Data4 (This would copy to "North East")


Any help is appreciated.

attach please a sample file