The way you have laid out the data in the Clients sheet makes it very difficult to extract partial data from it. It would be better organised as continuous columns of data in any order.

Hope this helps.

Pete