Macro or formula to transfer data from one sheet to another based on date and time

[Angrypirahna]

Hello,

i work in a postal plant and made a simple sheet to calculate the production on a specific machine, what I did id create two sheets, one where i enter the daily info on my shift, and the second one i basically copy paste the same data to have history on numerous days.

What I would like is help to come up with a way to copy that information automatically.

So essentially in sheet1 I manually enter data in cells C5:C11 and would like that data based on the date in C1 to be copied over into the proper cells in sheet2 for example based on august 10 2020 the data would have to copied to cells B49:H49 and so on has the date in sheet1 cell C1 changes.

Any help is much appreciated

Thanks