Populate Combo Box on Sheet with range of values

[psycoperl]

I would like to have a combo box drop down that would allow a user to select a date from a specified range (which is based on values selected on the "ToolSettings" sheet, specifically the "Select Admissions Term" value) - the combo box is sitting at "Select Test Date" (B10)

Barmap_File_Org.xlsm
	A	B
5
6	Select Admissions Term
7
8	Select Test Cycle Letter Prefix
9
10	Select Test Date
11
12
ToolSettings

Cells with Data Validation
Cell	Allow	Criteria
B6	List	=ValueList!$B$2:$B$27
B8	List	=ValueList!$A$2:$A$25

The values that I would like to have in the drop down box are based on the ValueList sheet. Where Column B (TermCodes) matches the "Select Admissions Term" value and then the dates from Column I (DateLists) is between the values of AdmTestStart (Column C) and AdmTestEnd (Column D)

Barmap_File_Org.xlsm
	A	B	C	D	E	F	G	H	I	J
1	CyclePrefix	TermCodes	AdmTermStart	AdmTermEnd		CycleLength			DateLists
2	A					0
3	B	1232	2022-10-01	2023-01-31		1			2022-10-01
4	C	1239	2023-02-01	2023-09-30		2			2022-10-02
5	D	1242	2023-10-01	2024-01-31		3			2022-10-03
6	E	1249	2024-02-01	2024-09-30		4			2022-10-04
7	F	1252	2024-10-01	2025-01-31		5			2022-10-05
8	G	1259	2025-02-01	2025-09-30		6			2022-10-06
9	H	1262	2025-10-01	2026-01-31		7			2022-10-07
10	J	1269	2026-02-01	2026-09-30		8			2022-10-08
11	K	1272	2026-10-01	2027-01-31		9			2022-10-09
12	L	1279	2027-02-01	2027-09-30					2022-10-10
13	M	1282	2027-10-01	2028-01-31					2022-10-11
14	N	1289	2028-02-01	2028-09-30					2022-10-12
15	P	1292	2028-10-01	2029-01-31					2022-10-13
16	Q	1299	2029-02-01	2029-09-30					2022-10-14
17	R	1302	2029-10-01	2030-01-31					2022-10-15
18	S	1309	2030-02-01	2030-09-30					2022-10-16
19	T	1312	2030-10-01	2031-01-31					2022-10-17
20	U	1319	2031-02-01	2031-09-30					2022-10-18
21	V	1322	2031-10-01	2032-01-31					2022-10-19
22	W	1329	2032-02-01	2032-09-30					2022-10-20
23	X	1332	2032-10-01	2033-01-31					2022-10-21
24	Y	1339	2033-02-01	2033-09-30					2022-10-22
25	Z	1342	2033-10-01	2034-01-31					2022-10-23
26		1349	2034-02-01	2034-09-30					2022-10-24
27									2022-10-25
28									2022-10-26
29									2022-10-27
30									2022-10-28
31									2022-10-29
32									2022-10-30
33									2022-10-31
34									2022-11-01
35									2022-11-02
36									2022-11-03
ValueList

Cell Formulas
Range	Formula
C3:C26	C3	=TEXT(fGetAdmStartDate(B3),"YYYY-MM-DD")
D3:D26	D3	=TEXT(fGetAdmEndDate(B3),"YYYY-MM-DD")
B4:B26	B4	=IF(RIGHT(B3,1)="2",LEFT(B3,3)&"9",LEFT(B3,3)+1&"2")
I3	I3	=C3
I4:I36	I4	=TEXT(I3+1,"YYYY-MM-DD")

How can I get the values to be in the combo box and then have the results useable by other formulas?