I apologize in advance for breaking any forum rules -- this is my first post

I have a Master Spreadsheet like so:


Col-A---Col-B------Col-C--------Col-D
State---Vendor----Orders------% on time
AK------Sam T.------12--------90
AK------Tom C.-------9---------91
AL------Bill R.------10--------89
AL------Mike G.------45--------95
AL------Matt L.------23--------99
AZ------Kyle K.------6--------92
AZ------Don H.------17--------88
AZ------Sam C.------14--------78
CA------Sean M.------5--------92
CA------Bob B.------45--------88
DE------Dave H.------10--------93
DC------Carl J.------18--------96
etc.

There are 100+ rows with many more states listed.

I then have multiple tabs representing each state. I want to transport only Alaska's data onto the AK tab, only the Alabama data to the AL tab, etc.

I have successfully transported the data with an IF statement:

=IF(Master!A:A="AK",Master!A:A,"") <--- for the Alaska tab in column A
=IF(Master!A:A="AK",Master!B:B,"") <--- for the Alaska tab in column B
=IF(Master!A:A="AK",Master!C:C,"") <--- for the Alaska tab in column C
etc... for each state


but the problem is that the data only transports to the corresponding row from the Master spreadsheet. So if you can imagine, AK's data is on the top rows, and then AL, AZ, CA, etc. so Maryland is on rows 20-23 and Texas all the way down to 45-49 etc. And the IF statement will work by conditionally transporting on the data I specify, but I can't figure out how to move the data to the top of each state's tab.

Is there a better way to do this? There has got to be! haha

Please help

Oh, and what I stated above is unclear then please ask me to clarify.

Thank you,
Mike