Series copy cells within edit

[Rock5150]

I have the attached here. As you can see I am doing a copy from another spreadsheet where it pulls every '3rd' row. How do I continue this without going into each cell and typing 12,15,18 for rows 3,4 and 5 etc

ALLEN, Dr. SEAN Net
ARCHULETA, MIKE Net
BANKS, ANTHONY Net

 

[Cubist]

Adjust the cell reference and change the 4 to however many rows you need.

=INDEX(A1:A100,SEQUENCE(4,1,1,3))

 

[Rock5150]

Adjust the cell reference and change the 4 to however many rows you need.

=INDEX(A1:A100,SEQUENCE(4,1,1,3))

Hello. So the original names are in one sheet within the workbook. I want to pull the names from this sheet into a new one so that it only catches the name with "NET" at the end. Where do I put the index formula in?

HD Ham and Egg spreadsheet for HD Invitational May 2024 everyone has everyone.xlsx
	A
5	ALLEN, Dr. SEAN
6	ALLEN, Dr. SEAN Net
7
8	ARCHULETA, MIKE
9	ARCHULETA, MIKE Net
10
11	BANKS, ANTHONY
12	BANKS, ANTHONY Net
13
14	BANKS Jr., ANTHONY
15	BANKS Jr., ANTHONY Net
16
17	BATTLE, JOE
18	BATTLE, JOE Net
19
20	BLAINE, JEREMY
21	BLAINE, JEREMY Net
22
23	BOLDEN, Dr. ANTHONY
24	BOLDEN, Dr. ANTHONY Net
25
26	BRISTER, TONY
27	BRISTER, TONY Net
28
29	BROWN, DON
30	BROWN, DON Net
Scores

Cell Formulas
Range	Formula
A5	A5	=W2
A6,A30,A27,A24,A21,A18,A15,A12,A9	A6	=A5&" "&"Net"
A8	A8	=W3
A11	A11	=W4
A14	A14	=W5
A17	A17	=W6
A20	A20	=W7
A23	A23	=W8
A26	A26	=W9
A29	A29	=W10

The second image is what I hope to look like. As you can see, right now I am manually typing the cell reference from the Scores spreadsheet one by one because I can't figure out the series fill sequence. Do I replace the reference with index and instead of A1:A100 I reference the other sheet?

HD Ham and Egg spreadsheet for HD Invitational May 2024 everyone has everyone.xlsx
	A
1	ALLEN, Dr. SEAN Net
2	ARCHULETA, MIKE Net
3	BANKS, ANTHONY Net
CALLEMOUT

Cell Formulas
Range	Formula
A1	A1	=Scores!A6
A2	A2	=Scores!A9
A3	A3	=Scores!A12

 

[Cubist]

If that's the case, try this.

=FILTER(Scores!A5:A30,ISNUMBER(SEARCH("Net",Scores!A5:A30)))

 

[Joe4]

Rock5150,
Please do not mark a post as the solution unless it actually contains the solution.
Thank you.