I have a worksheet that contains a very long list of specific data. I want
to create a column in that worksheet that users will be able to change the
status to "Active". Once status in worksheet is changed to "Active", I then
want the "Active" records to be visible on the worksheet called "ACTIVE".
The worksheet that houses the original data is called "Prospects".

i.e. User goes into workbook and inputs the word Active in the "ABC
Company" record (Column A - "Status") from "Prospects" worksheet, saves, and
closes. Without user doing anything, worksheet named "ACTIVE" has pulled all
information from "Prospects" and displays it on the "ACTIVE" worksheet. Any
notes added to the record on the "ACTIVE" worksheet automatically transfers
to "Prospects".

I tried to find something in help and it didn't work. Any help is
appreciated.