Dependent drop down list

[PurpleCat88]

Good morning!
I have a spreadsheet that is going to be used as a template for projects at my company. Because of this, a lot of the formulas and data are dynamic and can change a lot. Information is entered in sheets 1 and 2, and 3 will utilize drop downs to create a sequence of operations of motion parts. My issue is currently, the drop downs include all motions, which could range from a few hundred, to 1000+. The motions are specific to stations, where stations will be in column B and motions will be in column C. I have a separate data sheet where all my tables and formulas are to make things dynamic. I have made formulas to determine what row the motions start and finish between each station, and I am hoping to have drop downs where when 1 station is selected, only the motions for that station are listed in the second drop down. The layout of sheets 2 and 3 will be similar, but sheet 3 will have motions organized by sequence of operations. I'm sure there is a better way to do this, if it is possible, and would appreciate any help!

Book1.xlsx
	B	C	D	E	F
1	Section	Station	Devices
2	12345-01 Section 1
3		010_Station 1
4			Motion 1
5			Motion 2
6			Motion 3
7		020_Station 2
8			Motion 4
9			Motion 5
10			Motion 6
11	12345-02 Section 2
12		010_Station 3
13			Motion 7
14			Motion 8
15		020_Station 4
16			Motion 9
Sheet1

Book1.xlsx
	I	J	K	L	M	N
1	Stations	StationRow	StationsFound	StationRowOrder	MotionsStart	MotionsFinish
2				3	4	6
3	010_Station 1	3	1	7	8	11
4				12	13	14
5				15	16
6
7	020_Station 2	7	2
8
9
10
11
12	010_Station 3	12	3
13
14
15	020_Station 4	15	4
16
Sheet1

Cell Formulas
Range	Formula
I2:I16	I2	=IF(Stations<>"",Stations,"")
J2:J16	J2	=IF(Stations<>"",ROW(),"")
K2:K16	K2	=IF(J2="","",MAX(K$1:K1)+1)
L2:L16	L2	=IFERROR(INDEX([StationRow],MATCH(ROW()-ROW($J$1),[StationsFound],0)),"")
M2:M16	M2	=IF($L2<>"",[StationRowOrder]+1,"")
N2:N16	N2	=IF(AND($L3<>"",[MotionsStart]<>""),$L3-1,"")

Named Ranges
Name	Refers To	Cells
Stations	=Sheet1!$C$2:$C$16	I3:I16, I2:J2