VBA check the date if matched then copy and paste the data into their group

[rockyhawkky]

Hi there, i need a hand to help me with a simple VBA code, i got my sheet1 here

My Sheet.xlsx
	A	B	C
1	Date	Team	Name
2	05/10/2022	A	Lupin
3	22/10/2022	A	Fox
4	05/10/2022	B	Ruby
5	22/10/2022	B	Susan
6	05/10/2022	B	Garland
7	05/10/2022	A	Anthony
Sheet1

and here is sheet 2, i simply want to list their name in sheet2 here which matched their date, paste them to their group as yellow is the sample result

My Sheet.xlsx
	A	B	C
1	05/10/2022		22/10/2022
2	A		A
3	Lupin		Fox
4	Anthony
5
6
7	B		B
8	Ruby		Susan
9	Garland
10
11
Sheet2

any help would very much appreciate.