Transferring data from one list to another

[Ivn68]

I have a dates on sheet2

Date	Hours Worked	Hours off
08/01/24	4	4
08/05/24	5	2
08/07/24	10	0

I want to be able to find the date on sheet1 and then enter the corresponding values underneath the date

date	8/1/2024	8/2/2024	8/3/2024	8/4/2024	8/5/2024	8/6/2024	8/7/2024
hours
off
date	8/8/2024	8/9/2024	8/10/2024	8/11/2024	8/12/2024	8/13/2024	8/14/2024
hours
off
date	8/15/2024	8/16/2024	8/17/2024	8/18/2024	8/19/2024	8/20/2024	8/21/2024
hours
hours
off

so ideally I would enter all the info onto the list as the year goes on and then I would like to hit a button and it will transfer all the info onto sheet1. So the list will grow

thanks for any help

 

[Ivn68]

Yeah actual dates

 

[Ivn68]

Yeah actual dates

Actually the date is generated with a formula from the previous cell

 

[Georgiboy]

Is the date column in sheet2 column A?