Extracting data from a column in a table to another table/sheet

Good afternoon,

I am trying to extract the data from a specific column in a table, and have that data congregate in a separate table on a separate sheet. I am attaching a example of what I am trying to do so that you get a better idea.

The data I am trying to extract is located in the tab "Data Sheet". I am trying to extract data from a specific column, in this particular example from the column titled "Stage", and have said data be placed in a table in separate sheet depending on what they are. In this example, I am trying to take the "Closed Won" lines and extract them to the "Closed Won" tab, same with "Closed Lost". Each line will be a different opportunity name, but may be for the same company, the same product and the same dollar amount. Basically if there are duplicates, I still want them to show up.

Also, if I wanted to extract this same data based on the "Amount" column, would the formula be different? Since it would be numbers and not text, does that change the formula I need to use?

Thanks in advance for your help!!

That worked, thank you so much!

I do have an issue with this one though, it seems like once that data is extract to the separate tabs "Closed Won" and "Closed Lost", you cannot filter those results in a new table. Is there a way to get around this? I would like to be able to manipulate all the tabs, except for the "Data Sheet" tab.

I see, that is unfortunate. Thanks anyways you two!