There is no need for a macro for this. A simple counta function will do the trick.

On the output sheet in cell C2, type =COUNTA('Nov1:Nov30'!C2) and copy down. This will work so long as each daily sheet is in the same order