need help on data extraction

Advanced filter..

make a copy of the worksheet so you have your original and a second one.

Imagine this is your 4k list and you wanted to copy all the administrative assistants somewhere..

Create another table that looks like this:

This is your criteria

Now highlight the whole of your table including column headers (job title, name, phone number, email, whatever) and go to Data Ribbon, Sort and Filter, Advanced.

You will be asked for a list range, which should already be filled in, Criteria range which is the second table we made. Click ok and then it will filter the list for just those job titles in the criteria