Copy multiple information based on the name

[g3org]

Hello guys,
I am looking for a way to transfer all the information found based on a name.
I first workbook the name will appear many times, possible more than one time in the same date and in the second workbook i will have a sheet with al the names, any chances to move all the information trough the sheets for all the names?
Thanks in advance for your time and support!

ELAR Service Details Report_08_2022.xlsx
	A	B	C	D	E	F	G	H	I
1	Datum	Station	DSP-Shortcode	Zustellmitarbeiter	Route	Servicetyp	Geplante Dauer	Geplante Gesamtentfernung	Lieferungen zugestellt
2	08/01/22	DBW5	ELAR	Robert Ionut Lupu	CA_A8	Cargo Electric Bicycle	4 Std. 30 Min.	14	77
3	08/01/22	DBW5	ELAR	Florin Tincuse	CA_A9	Cargo Electric Bicycle	4 Std. 30 Min.	10	94
4	08/01/22	DBW5	ELAR	Vasile Daniel Paul	CA_A10	Cargo Electric Bicycle	4 Std. 30 Min.	19	110
5	08/01/22	DBW5	ELAR	Sergiu Arnaut	CA_A11	Cargo Electric Bicycle	4 Std. 30 Min.	23	77
6	08/01/22	DBW5	ELAR	Robert Ionut Lupu	CA_A11	Cargo Electric Bicycle	4 Std. 30 Min.		1
7	08/01/22	DBW5	ELAR	Vasile Daniel Paul	CA_A12	Cargo Electric Bicycle	4 Std. 30 Min.	22	49
8	08/01/22	DBW5	ELAR	Gheorghe Barbu	CA_A13	Cargo Electric Bicycle	4 Std. 30 Min.	22	64
9	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A13	Cargo Electric Bicycle	4 Std. 30 Min.		14
10	08/01/22	DBW5	ELAR	Florin Tincuse	CA_A14	Cargo Electric Bicycle	4 Std. 30 Min.	19	50
11	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A15	Cargo Electric Bicycle	4 Std. 30 Min.	26	61
12	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A16	Cargo Electric Bicycle	4 Std. 30 Min.	21	78
13	08/01/22	DBW5	ELAR	Toader Durila	CA_A17	Cargo Electric Bicycle	4 Std. 30 Min.	27	83
14	08/01/22	DBW5	ELAR	Nicolae Nesu	CA_A18	Standard Parcel	9 Std.	38	178
15	08/01/22	DBW5	ELAR	Alexandru Iacob	CA_A19	Standard Parcel	9 Std.	54	175
16	08/01/22	DBW5	ELAR	Sergiu Arnaut	CA_A20	Cargo Electric Bicycle	4 Std. 30 Min.	26	71
17	08/01/22	DBW5	ELAR	Robert Ionut Lupu	CA_A21	Cargo Electric Bicycle	4 Std. 30 Min.	35	58
18	08/01/22	DBW5	ELAR	Toader Durila	CA_A22	Cargo Electric Bicycle	4 Std. 30 Min.	28	64
19	08/01/22	DBW5	ELAR	Gheorghe Barbu	CA_A23	Cargo Electric Bicycle	4 Std. 30 Min.	23	63
Tabelle1

Book1
	A	B	C	D	E	F	G
1	Adrian Alexandru
2
3
4
5
6
7
8
9
10
11
12
13
14
Adrian Alexandru

 

[Peter_SSs]

Is this what you mean?

g3org.xlsm
	A	B	C	D	E	F	G	H	I
1	Adrian Alexandru
2	Datum	Station	DSP-Shortcode	Zustellmitarbeiter	Route	Servicetyp	Geplante Dauer	Geplante Gesamtentfernung	Lieferungen zugestellt
3	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A13	Cargo Electric Bicycle	4 Std. 30 Min.	0	14
4	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A15	Cargo Electric Bicycle	4 Std. 30 Min.	26	61
5	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A16	Cargo Electric Bicycle	4 Std. 30 Min.	21	78
6
Adrian Alexandru

Cell Formulas
Range	Formula
A3:I5	A3	=FILTER(Tabelle1!A2:I2000,Tabelle1!D2:D2000=A1,"")
Dynamic array formulas.

 

[g3org]

Is this what you mean?

g3org.xlsm
	A	B	C	D	E	F	G	H	I
1	Adrian Alexandru
2	Datum	Station	DSP-Shortcode	Zustellmitarbeiter	Route	Servicetyp	Geplante Dauer	Geplante Gesamtentfernung	Lieferungen zugestellt
3	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A13	Cargo Electric Bicycle	4 Std. 30 Min.	0	14
4	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A15	Cargo Electric Bicycle	4 Std. 30 Min.	26	61
5	08/01/22	DBW5	ELAR	Adrian Alexandru	CA_A16	Cargo Electric Bicycle	4 Std. 30 Min.	21	78
6
Adrian Alexandru

Cell Formulas
Range	Formula
A3:I5	A3	=FILTER(Tabelle1!A2:I2000,Tabelle1!D2:D2000=A1,"")
Dynamic array formulas.

Sir, it is exactly what I wanted. Many thanks!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.