Sheet 1 has 2K worth of rows. Need to auto pull certain ones to sheet 2 and sheet 3

Hello all,

Don't know where mt question really goes. So here it is. I have a Excel 1013, i have a workbook with currently one sheet and that sheet has about 2,000 rows with 7 columns. What I would like to do is this: Have Excel automatically look through sheet 1 and with my given parameters to copy the whole row to a different sheet in the workbook.

Here are the headers for the columns: Job #, Client, Project Decription, Year, Box #, Folder, Open Job

What I want: I want to have Excel to search the Client row and when it finds "Client A" copy the whole row to Sheet 2. And When is finds "Client B" copy that row to sheet 3...

If I can not do this please let me know. I need to keep Sheet 1 complete.

Thank you,
Conrad

Is there more than 1 row for "Client A" and "Client B", etc.? Or will they have multiple rows of data?

Capture.JPG

Ok, there is a small pic of my workbook. There will be multi-Rows of data for each client. Instead of selecting the whole sheet and sorting it then going to where i might want to go, I would like to just open a sheet to the client.