Formula to Copy highlighted rows into another sheet in same workbook?

Hi All!

What I'm doing/using the workbook for:

• I have created a workbook, using conditional formatting, that highlights an entire row if a specified column contains a certain word. It does this for a list of 12 specified words.
• I copy a data set (with a specific data format) and paste it into my workbook
• It highlights the rows of interest for me for ease of view/to save time from looking to see if the row qualifies to be put into the final workbook sheet of qualified data sets

My Question:
How do I then have Excel take only the highlighted rows and automatically copy paste them into sheet in the workbook?

Thanks! and thanks for the quick response.

Would a pivot table allow me to only import rows with a specific format (like the highlighted cells)?

I thought about using a Filter, but when I first paste in the data sets they're often between 200 - 500 lines of data. Clicking and un-clicking would be a nightmare then is what I was thinking.

However...now that I think about it, yeah, I guess I could simply add the "list of 12 qualifiers" into the pivot table's "report filter" and then it would just show the data I was interested in then, right? Hmmm...There are things I don't like too much about the pivot tables though, so if possible I'd like to try to figure out another way.

Definitely, I'll upload a picture here in a bit (gotta run an errand real quick). Thanks, man!