Hide, Unhide Rows and count!?

Hi Stan,

Any help would be appreciated! This is taking up alot of my time, and just gets more a more frustrating!

As you can see from the data valiadtion, there are many more sheets that I work with (had to delete some of the calcs and sheets as it was making the attachement too large)

Thanks

Wil