Hard Find And Copy

I have a web query which updates regulaly, however, a lot of information is prodcued which i dont need or want. I know that the information I do want will always be in a single column, usually A or C.

The problem is further complicated. If I have the following search list on sheet1 column A:

Search List (sheet1) Web Query results (Sheet2) Known bad data (sheet1)
A AB AB
B E DE
C F
D A
E B
F C
G DE

I need to be able to search through the information returned by the web-query, and find the first exact match in the returned data that exists in the lsearch ist, so in the above table the first exact match would be row 2 which contains only an E. Row 1 with AB is not a match as it does not exist in the search list.

So, having identfied where the first entry I am interested in (E) is, we need to copy all the cells below it until we find the first entry which then exists as an exact match in Known bad data column.

If all goes to plan, running the macro on the above data would output the following to sheet 1:
E
F
A
B
C