I have a Wookbook with over 50 wooksheets. There are 2 sheets that deal with a us state. The first one have information with names on it. The second one also has names on it. What I want to do is create a 3rd wooksheet that will compare the previous 2 worksheets and put only the names that match from the 2 wooksheets onto a 3rd worksheet.

Example of wooksheet:

AK People, AK People2, AL people, AL people2. etc, etc.