Using one daily sheet to fill in a weekly total

[Svargo]

Hello!

I am trying to have one data entry worksheet for Monday-Sunday that can populate the daily amounts to a weekly sheet. The kicker is, I dont want to have multiple Monday-Sunday sheets. I need the data to automatically go to the next week. So if I put a value in the data entry sheet for Sunday it would go Sunday the 1st. The next week I want to to use the same data entry sheet for Sunday  but I want the values to go to Sunday the 8th. Is this possible? I am using Microsoft 365 2018

Thanks for the help!

Steve

[#2]

@Svargo Use Excels built-in capabilities to summarise the data, however you want. For instance with one or more pivot tables. 

If you add real dates to each entry, you don't have to say it's a Sunday. Excel knows this and you can have it display the name of the day, which you can then use for filtering or summarising.

All it requires is a Data Refresh All, after you have entered more data. The attached workbook is just an example of what's possible.