Count of clients at specific stage

I always learn something new around here. Cutter's post is the first time I have seen a range of worksheets used in a formula. That's a very elegant solution using just formulas.

Another approach using the layout you have would require VBA. The VBA would loop through each worksheet, looking at what stage that client is in. I have attached an implementation for your example.