I need assistance with a formula...

I have a workbook that tracks work performed for each day of the month.
there are 32 sheets 31 for each day of the month and 1 for productivity
report which take the totals for each day and puts it on to one page. Column
A is the permit type which is type 1 thru 9. What I want to do now is on a
new work sheet in the same workbook I would like to, for each day in the
month, populate that page so it will tell me how many of each type of permit
were done on a specific day. For example on day 1 the person processed 4 type
1's, 6 type 2's and so on and so on.

I would like the worksheet to auto populate based on the information
provided on the other 31 worksheets

Thank you for your help.