Auto Filter by Row Number

[fireguy7]

Hello - I've searched everywhere and can't find the answer.

Long and short is I want to code to Auto filter but use row numbers instead of text value.

For Example with the below instead of filtering field 8 by value "Sch" I'd want to filter to show row 5

in the end I want to input the rows in another tab and have it filter the table to show only these rows.