cell info into formula

[JOEE1979]

Cell 'D9' is the name of a worksheet
Cell 'D10' has the formula =XLOOKUP(B10,'Jan 05 - Feb 16 2024'!$C$6:$C$200,'Jan 05 - Feb 16 2024'!$L$6:$L$200)

How would I be able to automatically extract 'D9' into my formula?

Thank you

HOS - Copy - Copy.xlsm
	D	E
9	Jan 05 - Feb 16 2024	Feb 23 - Apr 05 2024
10	16-Feb-24	5-Apr-24
calculate (2)

Cell Formulas
Range	Formula
D10	D10	=XLOOKUP($B$10,'Jan 05 - Feb 16 2024'!$C$6:$C$200,'Jan 05 - Feb 16 2024'!$L$6:$L$200)
E10	E10	=XLOOKUP($B$10,'Feb 23 - Apr 05 2024'!$C$6:$C$200,'Feb 23 - Apr 05 2024'!$L$6:$L$200)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A6,D1:XFD6,C3:C4,7:1048576	Cell	contains a blank value	text	YES

 

[StephenCrump]

D10: =XLOOKUP($B$10,INDIRECT("'"&D9&"'!$C$6:$C$200"),INDIRECT("'"&D9&"'!$L$6:$L$200"))