Need Help! Rolling total for Last 7 Days

Hello,

I have a problem that I have not been able to solve by reviewing other questions asked before.

Overview: I have a worksheet called "Workspace" that totals the data in sheet's 1-3. Every morning, sheets 1-3 are filled with yesterdays data which are totalled using =VALUE at the top of the workspace sheet. Then I run a Macro to "Rollup" yesterdays data, which copys the "live" data, inserts a new row at the top of the chart and pastes only values (so the formulas to not come with the new row). On the next sheet labeled "Work hours total" I need to have rolling calculations of "Last 7 Days", "Totals This Month", and "Year-to-Date"

Problem: When using the formulas on this blog post to fill my tables; my "Last 7" table resets to '0' across the board every Monday, I want it to be a rolling Last 7, so at any given day I can determine what the totals are for the last 7. As is right now, that formula is more like a "Calculate this week" option.

Is there a better way to do this?

I have attached an example Workbook for your reference, it is not actually the workbook I am trying to make work because I cannot share that with you guys, but it is very similar on a much smaller scale.

Sample Company Roll-up.xlsm