Extract Data from a spreadsheet based on a selection in a column

[JSH720]

I need to keep the original information intact, but open another spreadsheet based on criteria in a specific row. For example, The row has three possible selections for county in it, A< B<C I need a new spreadsheet to open that splits the A to one tab, The B to a second tab, etc. It would then be saved separately I may need to run this on other columns with other criteria (including a phrase such as not on Texas Spreadsheet", "inactive", etc. for other projects.

Is there a simple macro that I can set the criter and row for that criteria and accomplish this?

Thanks.