Automatically copy/paste refreshed data into row of "next line" in another sheet

I've attached a sample worksheet so show an example of what I want to do.

When I refresh the data, row 5 of sheet 1 updates to the next date and next higher number. After refreshed, Excel automatically copies the entire row and pastes it into sheet 2 on the correct corresponding row so I can create a history of data from each day.

Is this possible?

Thanks!