comparing two sheets columns extract data into new sheet

I am trying to have a list in one sheet and compare each cell's value to another sheet's column to display the results. Extract only that data into another sheet for text file export.
If I use the filter and copy and paste the name into the filter field it remains in the macro script.
Here is the script and it works for the one title only.

Please Login or Register  to view this content.

The Wild Girl has to be the value of the cell selected from Sheets("FINAL") Each time it does it's thing it would move down from A1 until there are no more titles in column A. Each pass I am hoping to copy information from the sheets into another sheet and export. I have the script for this see below.

Please Login or Register  to view this content.

Thanks for any help

I found this code on another thread it worked great.

Please Login or Register  to view this content.