Regarding your worksheets you say: named them mm/dd
but this cannot be correct as "/" is not allowed in worksheet names.
If your worksheets are named mm_dd, you can use this macro:
(If the worksheet names are slightly different, you can modify the code)
There are two lines where you can set the address of the cell to hold the formula for the prior day's running total and the address of the cell containing the running total.
Dim strWsNameToday As String
Dim strWsNameYesterday As String
Dim dtToday As Date
Dim strAddrYesterday As String
Dim strAddrToday As String
Dim strFormula As String
Dim m As Integer
Dim d As Double
'setup cell address of cell containing the daily total
strAddrYesterday = "A34"
'setup cell address of cell to hold formula for yesterday's total
strAddrToday = "A33"
'loop through each day's worksheet
For m = 1 To 12
'loop days - uses the day before the first day of next month
For d = 1 To DateSerial(Year(Now), m + 1, 1) - 1
'create todays date
dtToday = DateSerial(Year(Now), m, d)
If dtToday <> DateSerial(Year(Now), 1, 1) Then
'create today's worksheet name
strWsNameToday = _
Format(Month(dtToday), "00") & "_" & _
'create yesterday's worksheet name
strWsNameYesterday = _
Format(Month(dtToday - 1), "00") & "_" & _
Format(Day(dtToday - 1), "00")
'create formula eg "='01_01'!A34"
strFormula = "='" & strWsNameYesterday & "'!" & strAddrYesterday
'place formula on today's worksheet
Also as you are dealing with 365 worksheets, that you can edit or enter data or formatting to all of them at once by grouping the worksheets first.
Click the first daily worksheet in the name tab list and hold down the Shift key and click the last one. Changes made to the visible worksheet will be applied to all the selected group of worksheets.
To ungroup either click on the tab name of an ungrouped worksheet or right-click on a the grouped worksheets names and select Ungroup Sheets.