Extract a subset of data from one sheet and copy to another sheet

I have a spreadsheet with 10 columns (first name, last name, Street, town, zip etc) and 40,000 rows of names. This is a list of registered voters.   I want to search for specific names of folks Who h...