Copy values from one sheet to the other

Hi everyone
I know the title sounds a little basic but actually it's a big problem I have.
I am creating a work control excel workbook. I want a worksheet people will enter values everyday and another one that will compile the values.
That way, the user will enter the date, the required informations that are compiled on the other sheet so the next he can changes the date, the fields clear themselves, enter the new informations that are copied next to the ones from the day before in the compilation sheet.
I don't think I need to write a macro in vba in order to be able to do this but if needed I don't fear doing it. My problem is I have a hard time figuring how to process.
Have anyone ever done something like that? Do you have hint and tips about how I can do that?
Thanks for helping!

Bénédict

Hello Bénédict!

You should use data validations for your people and copy special only values to your sheet. I would do it if I were you.