Auto Add/Remove rows for dates each month

Hi,
I have a spreadsheet to track energy usage each day, which calculates totals, averages, costs, etc. The daily data usage is pulled from another spreadsheet.
I am looking for a way to duplicate the sheet for a new month which will update the number of days depending on what the month is. For example, June has 30 days so the data is in rows 10 - 39 with totals in row 40. When I duplicate the sheet for July (31 days) I need to add a row for 31st before the totals row and update formulas to include the additional row.
Is there a way to get this to happen automatically using a macro?

Thanks.

You could put the totals above row 10 and refer to the full range (i.e. for a 31-day month). You can apply conditional formatting for the final few days (i.e. for 29th onwards, to account for February) which will blank out the date if the month of that date is not the same as the month in row 10. This will happen automatically.

Hope this helps.

Pete