I have 12 worksheets, one for each month
This was not evident from the file you attached.

What is the daily report you want to send? Is it that table in the lower part of sheet? Will you have that on every sheet?

I recommend you have one sheet with the daily report, build it with formulas, and the VBA can generate the PDF and mail it, if that's what you need to do. But first I need to know what your report looks like.