Filter multiple choices in to one spreadsheet

[GMC The Macro Man]

Hi there
I have a daily spreadsheet that has about 20 columns and over 3000 rows where I need to filter out a selected list of users.
The image below is a slimmed down version and the User List (Column G) is a TABLE which is normally on a different TAB within the Workbook
The Unique Identifier is Column A (USER) which could hold up to 200 individual users.
My task is to go through all of the User (Col A) and if the User appears in the User List (Col G) then I need to copy the data in that row and paste to a new Line in a new worksheet
I have tried both V & X lookup, FILTER, and VBA but I'm struggling to get any formula to LOOKUP the User list and continue until all Users have been verified.
I have also added an image below of what my expected output should look like
Any help would be appreciated

In this demo, there was only 2 users who where in the User List and this is the expected output

 

[JamesCanale]

I'm not sure if I understand this:

MrExcelPlayground17.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	User	Dept	Manager	Ticket			Users List			User	Dept	Manager	Ticket
2	A	1	M	1			A			A	1	M	1
3	A	1	M	2			C			A	1	M	2
4	B	2	N	3			H			C	3	O	5
5	B	2	N	4			J			H	8	T	13
6	C	3	O	5						H	8	T	14
7	D	4	P	6						H	8	T	15
8	D	4	P	7						J	10	V	18
9	E	5	Q	8						J	10	V	19
10	E	5	Q	9						J	10	V	20
11	E	5	Q	10
12	F	6	R	11
13	G	7	S	12
14	H	8	T	13
15	H	8	T	14
16	H	8	T	15
17	I	9	U	16
18	I	9	U	17
19	J	10	V	18
20	J	10	V	19
21	J	10	V	20
Sheet4

Cell Formulas
Range	Formula
J2:M10	J2	=FILTER(A2:D21,ISNUMBER(XMATCH(A2:A21,G2:G5,0)))
Dynamic array formulas.

 

[GMC The Macro Man]

Hey @JamesCanale
This has worked perfectly, thank you so much. I have a little formatting to do like get rid of ZERO's and remove a couple of columns which I think I know how to manage.
1 more question if I may?
On the demo above you filtered on the data A2:D21. My daily reports will always be the same no of columns but will not be the same no of rows and I don't want to change the FILTER formula daily.
Is there a method on how to select the array without setting defined cells

Thanks again for solving this for me, I really appreciate you taking the time to look at it

 

[JamesCanale]

Format your data as a table. Excel will manage the rows you need.

MrExcelPlayground17.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	User	Dept	Manager	Ticket			UserList			User	Dept	Manager	Ticket
2	A	1	M	1			A			A	1	M	1
3	A	1	M	2			C			A	1	M	2
4	B	2	N	3			H			C	3	O	5
5	B	2	N	4			J			H	8	T	13
6	C	3	O	5						H	8	T	14
7	D	4	P	6						H	8	T	15
8	D	4	P	7						J	10	V	18
9	E	5	Q	8						J	10	V	19
10	E	5	Q	9						J	10	V	20
11	E	5	Q	10
12	F	6	R	11
13	G	7	S	12
14	H	8	T	13
15	H	8	T	14
16	H	8	T	15
17	I	9	U	16
18	I	9	U	17
19	J	10	V	18
20	J	10	V	19
21	J	10	V	20
Sheet4

Cell Formulas
Range	Formula
J2:M10	J2	=FILTER(Table2,ISNUMBER(XMATCH(Table2[User],Table3[UserList],0)))
Dynamic array formulas.

 

[Fluff]

You can also select a range larger than you need (without going to over the top)

=FILTER(A2:D5000,ISNUMBER(XMATCH(A2:A5000,G2:G5,0)))

 

[GMC The Macro Man]

You can also select a range larger than you need (without going to over the top)

=FILTER(A2:D5000,ISNUMBER(XMATCH(A2:A5000,G2:G5,0)))

Thanks for your input Fluff. Both ways actually work really well

 

[Fluff]

Glad we could help & thanks for the feedback.