I am looking to make a master list that I can separate into 3 different work sheets according to a certain column containing key words.

Example:

Master list

Andrea 456-456-4568 123 Ave 4 Columbus Ga 12345 Balance Active
Jeanine 789-789-7896 45666 ave A Columbus Ga 45 Balance Inactive

I want to make an "Active" worksheet and an "Inactive" worksheet by using a formula to extract the whole row according to the Active/ inactive status.

Thanks for taking the time to help.