Dynamic Xlookup

[windies17]

Hi folks

I have taken over a spreadsheet, the data is updated every day based on the date. The District sheet has data updated every day, when a new day arrives we unhide the sheet and put the data in. On the second data sheet I have used an xlookup to bring the information from district. What I am looking to do is bring in the data based on the date in N23. pulling from district sheet to the data sheet. Any help would be greatly appreciated.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
2		Total	North East	East	Total Area	East Gate	North Gate	South Gate	South District	Total	Under side	Over Side	Length Ways	Area
3	4/3/22		89	98		75	71	87	532		532	67	65	0
4	4/2/22		98	98		48	65	37	29		29	29	29	0
5	4/1/22		87	43		39	32	46	10		10	8	198	0
6	3/31/22		76	16		726	59	59	60		60	98	52	0
7	3/30/22		124	976		54	1	87	78		78	3	78	0
District

Cell Formulas
Range	Formula
A3	A3	=TODAY()
A4	A4	=TODAY()-1
A5	A5	=TODAY()-2
A6	A6	=TODAY()-3
A7	A7	=TODAY()-4

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N
23	4/1/22	89	98	75	71	532	67	65	0	87	532		2/1/22
24													2/3/22
25													2/2/22
26													2/1/22
27													3/31/22
28													3/30/22
Sheet2

Cell Formulas
Range	Formula
C23:L23	C23	=XLOOKUP(C22,District!$C2:$N2,District!$C3:$N3)

Named Ranges
Name	Refers To	Cells
total1	=District!$C$3:$N$3	C23:L23