How to create a macro to automatically copy data from the cells of one sheet to the second Google spreadsheet?

Question

Macros

Good afternoon!

There is Sheet1. In it, I fill in the data (client's full name) in column A, phone number in column B, mail in column C, order number in column D.

There is Sheet2. On sheet 2, there are only 3 columns of full name - column A, order number - column B, Phone - column C. Sheet 2 is a kind of database that collects data on customers daily.

We need a macro that at 23:59:59 every day will take data from the filled rows of sheet 1 (range A1: D50) and copy the filled values ​​down to the table of sheet 2, i.e. under the already filled data, without deleting the data from sheet 1.

On the second day, sheet 1 is reset manually and the data in the cells is overwritten and at 23:59:59 data is again taken from sheet 1 down sheet 2.

If it is impossible to do it in time, then you need a button which will do it.