Automatically search, copy into new sheet

Please help.
I want to search a document (of 20,000 contacts) remove or copy certain job functions (which are in columns) then move the whole of that row into a new spreadsheet or page.

The sheet is a list of data, company names, individual names, job function and email address.

So I want to find the job function "Sales manager" and then that particular row - i.e. the contact, move into a new sheet for "sales managers".

Can this be done?

The short answer is YES, it can be done. If you want specifics, please share a piece of your file with dummy data.