Not sure what you want here. Think this is what you are looking for:

Select your range, Data-Filter-Autofilter. You will now have a drop
down for each of your headers. Select the client you want, copy the
rows and paste to your client worksheet.

If this is not what you are after a macro could do the job.

Giff