Move data from daily to monthly sheet

I have several worksheets that I use to total up the prior day's business - sales, payouts, etc. I generate a new sheet every day and it is named by DOW and date, both the tab and at least one cell.

I also have several monthly sheets that I use to track certain information from the daily sheet - sales of a particular item or to compare daily sales totals. These sheets are generated every month and have a row for every day.

The 2 sheets are in different workbooks

I would like to automate my process so that when the macro runs to make the new daily sheet it sends the data from the daily sheet to the monthly sheet. I've had some success transfering from the daily to the monthly sheets within the same month but I'm at a loss as to how to grab the data when a new monthly sheet gets made without having to manually re referance stuff.

The sheets I uploaded show a sheet from each workbook and show a daily and monthly sample file to show what I'm trying to do.