Count of clients at specific stage

The attached spreadsheet shows a simplified version of my problem.

I have many tabs, each that represents a different client (in the example they are the tabs called first, second, third), and they show what stage the client is currently at by indicating the date they went to that stage.

On the Stats tab I want to indicate how many clients are at each stage, in this case we have 1 client at stage 1.3 and 2 clients at 1.4.

Is there a simple way to do this for a lot of clients? Maybe my spreadsheet could be formatted in a different manner to make this simpler?

Many thanks

Maybe this instead:

Add an extra column to each client sheet to indicate the stage they are at - like this in cell C3 of each sheet:

=IF(B3=MAX(B$3:B$11),B3,"")

then do your count on that column so on your main sheet in B3 copied down:

=IF(COUNT(first:third!C3)=0,"",COUNT(first:third!C3))

You would have to insert new client sheets between the existing sheets, not just add them on at the end unless you add blank sheets as bookends and use those bookend names in the formulas. The bookend sheets could be hidden.

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.