Hi
If I understand you correctly you could have a formula in column E (once you have pasted the smaller files into column D) that check for a match between columns A and D and puts a YES in column E, you can then filter on YES in Column E. So the formula would look like this:

=IF(A1=D1,"Yes","No")

Hope this helps.
Tony