You may add such code to ThisWorkbook module:
On opening a file (morning given day I assume) the current content of Data sheet is copied to a newly created sheet named by that day: YYYYMMDD
(may be it would be wise to save the file automatically in that moment, but on the other hand, if you make some changes and don't save the file - the situation is still the same as before opening first time given day)
If the file is closed and opened again that day the presence of YYYYMMDD sheet is tested and if it is present is left as it was.
See sample file (recycled from one of other threads).
Download the file and open, but not allow the macros. It just contains Data and 20220622 sheets. close it and open once again allowing macros - the content of DAta will be copied to 20220623 and DAta will be the active sheet.
Bookmarks