Non-VBA - Copy Rows to New Sheet if Cell Contains Specific Text - Self Adapting

[WillowLion]

Hello,
I am attempting to copy from one sheet to another based on the value of a cell with a data validation list. I need the formula to adapt to information from Sheet1 if data should change.
Details below:
I need to copy rows of data (columns A-F only) from Sheet 1 to Sheet2 IF data in column F of Sheet 1 contains "Enrolled" (does not need to be an exact match). Column F contains a dependent data validation list. Needs to copy by row, columns a-f only into sheet2 of the same workbook (destination are the same columns, A-F).

Sheet1:

Dependent Data Validation List - Sheet1:

Sheet2 (Columns G-H shown only as example, titles redacted for sensitive data):

*Note: I CANNOT use VBA or macros as this workbook needs to operate on Excel online. I also don't have Scripts.
Can this be done?
Thank you for any help you all can give!

 

[JamesCanale]

The FILTER function aught to make quick work of it:

MrExcelPlayground8 (version 1).xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	MRN	Date	Name	NameLast	Call Type	Dispo			MRN	Date	Name	NameLast	Call Type	Dispo
2	1	5/3/2022	A	Jones	Inbound	Follow up			2	5/1/2022	B	Smith	Outbound	Enrolled - Dual
3	2	5/1/2022	B	Smith	Outbound	Enrolled - Dual			4	5/5/2022	d	Named	Inbound	Patient Unavailable but Enrolled
4	3	5/5/2022	C	Test	Inbound	Patient Follow Up
5	4	5/5/2022	d	Named	Inbound	Patient Unavailable but Enrolled
6	5	5/2/2022	e	Anyone	Outbound	Follow Up
7	6	5/7/2022	f	Trouble	Inbound	Patient Followup
Sheet18

Cell Formulas
Range	Formula
I2:N3	I2	=FILTER(A2:F7,ISNUMBER(SEARCH("Enrolled",F2:F7)))
Dynamic array formulas.

 

[WillowLion]

Thank you for your help! This worked.