Selecting Specific Data within a Table
 

We have a shared worksheet that holds application data, eg. customer names,
app numbers, case status & which employee is reviewing the application - the
sheet records the status of application as pending, completed or declined.
How can I search & select all pending deals for each employee & transfer to
another worksheet so that each individual has a pending worklist of pending
deals only