Excel:Filtered Columns in different sheets apply same filter?

I will try to explain it the best I can.

So I have a list of 15000 data, and i have different variables column B= Last Name 1, C= Last Name 2,D= First Name, E= Second Name. Also one sheet per each sheet 1 = Last Name 1, 2= Last Name 2,3= First Name, 4= Second Name.

I went ahead and created one sheet per each variables but now i need to join them all to verify how many of the 15000, i found had input errors. Please don't get confused I know I could easily add them all and get the total, but I will detail and example:

Lets say that in sheet 1 i filtered all the last names "Smithj" but in sheet 3 I filtered the "Sanndra". So i don't know how many of the ones i filtered in sheet 1 are also shown up in sheets 2,3 and 4.

Please let me know if you need more detail. Thanks in advanced

Ok great thank you so much.

I tried uploading the file but it weighs 8.4 MB, i tried compressing it and no luck. So i'm sending you this link maybe you can download it from there.

http://www.sendspace.com/file/oq3qvh

Thanks in advanced.

Hi,

Lets say that in sheet 1 i filtered all the last names "Smithj" but in sheet 3 I filtered the "Sanndra". So i don't know how many of the ones i filtered in sheet 1 are also shown up in sheets 2,3 and 4.

In Honduras we use 2 last names.
Sheet 1= Input Errors=First Last Name
Sheet 2= Input Errors=Second Last Name
Sheet 3= Input Errors=First Name
Sheet 4= Input Errors=Second Name

What I meant was: I filtered in each sheet I filtered it by input mistakes, I had to do it manually as some names a written different in my country so I can't spell check it if not I think everything would be wrong.

I want to apply the filter I selected in sheet 1 to all the other sheets so it can show me all the input mistakes, instead of me doing it all over again.

Hope this is better