out of my league, need help

[JOEE1979]

This is way out of my league and I need someones help
I previously had someone help me with some formulas but now I need to add another column.


I added a blank column to the worksheet below (T) and need to extract info from another worksheet

Schedule 4 Tracker - COPY.xlsx
	T	U	V	W
3			Saturday
4		2	2
5		45597	2449	1
6		0	2453	2
7		0	2488	3
8		0	2490	4
9		0	2491	5
Current Month

Cell Formulas
Range	Formula
V3	V3	=V4
U4	U4	=S4+1
V4	V4	=S4+1
U5	U5	=SUMIFS((INDIRECT(AL9&"!I:I")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(U$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W5,(INDIRECT(AL9&"!B:B")),V5)
V5	V5	=SUMIFS((INDIRECT(AL9&"!B:B")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(V$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W5)
U6	U6	=SUMIFS((INDIRECT(AL9&"!I:I")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(U$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W6,(INDIRECT(AL9&"!B:B")),V6)
V6	V6	=SUMIFS((INDIRECT(AL9&"!B:B")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(V$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W6)
U7	U7	=SUMIFS((INDIRECT(AL9&"!I:I")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(U$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W7,(INDIRECT(AL9&"!B:B")),V7)
V7	V7	=SUMIFS((INDIRECT(AL9&"!B:B")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(V$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W7)
U8	U8	=SUMIFS((INDIRECT(AL9&"!I:I")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(U$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W8,(INDIRECT(AL9&"!B:B")),V8)
V8	V8	=SUMIFS((INDIRECT(AL9&"!B:B")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(V$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W8)
U9	U9	=SUMIFS((INDIRECT(AL9&"!I:I")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(U$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W9,(INDIRECT(AL9&"!B:B")),V9)
V9	V9	=SUMIFS((INDIRECT(AL9&"!B:B")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(V$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W9)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D26:E45,D47:E66,D68:E87,D89:E108,D110:E129,V110:V129,V89:V108,V5:V24,V68:V87,V47:V66,V26:V45,S110:T129,S89:T108,S68:T87,S47:T66,S26:T45,P110:Q129,P89:Q108,P68:Q87,P47:Q66,P26:Q45,M110:N129,M89:N108,M68:N87,M47:N66,M26:N45,J110:K129,J89:K108,J68:K87,J47:K66	Cell Value	=0	text	YES
D5:E24,G5:H24,J5:K24,M5:N24,P5:Q24,S5:T24,V5:V24,D26:E45,G26:H45,J26:K45,M26:N45,P26:Q45,S26:T45,V26:V45,D47:E66,G47:H66,J47:K66,M47:N66,P47:Q66,S47:T66,V47:V66,D68:E87,G68:H87,J68:K87,M68:N87,P68:Q87,S68:T87,V68:V87,D89:E108,G89:H108,J89:K108,M89:N108	Expression	=C5>0	text	NO
V5:V24,D5:E24,S5:T24,P5:Q24,M5:N24,J5:K24,G5:H24	Expression	=MONTH(D$4)<>MONTH($D$2)	text	YES
D5:V19	Expression	=TODAY()>D$4	text	NO
D4:E4,D109:E109,D88:E88,D67:E67,D46:E46,D25:E25,V25,V46,V67,V88,V4,S25:T25,S46:T46,S67:T67,S88:T88,S4:T4,P25:Q25,P46:Q46,P67:Q67,P88:Q88,P4:Q4,M25:N25,M46:N46,M67:N67,M88:N88,M4:N4,J25:K25,J46:K46,J67:K67,J88:K88,J4:K4,G25:H25,G46:H46,G67:H67,G88:H88,G4:H4	Expression	=MONTH(D4)<>MONTH($D$2)	text	YES
D4:E4,D109:E109,D88:E88,D67:E67,D46:E46,D25:E25,V25,V46,V67,V88,V4,S25:T25,S46:T46,S67:T67,S88:T88,S4:T4,P25:Q25,P46:Q46,P67:Q67,P88:Q88,P4:Q4,M25:N25,M46:N46,M67:N67,M88:N88,M4:N4,J25:K25,J46:K46,J67:K67,J88:K88,J4:K4,G25:H25,G46:H46,G67:H67,G88:H88,G4:H4	Expression	=OR(WEEKDAY(D4,1)=1,WEEKDAY(D4,1)=7)	text	YES
D5:V19	Expression	=TODAY()=D$4	text	NO

I would like the Garage column "F" from '2024' to show up in 'Current Month' column "T"
Keep in mind, the unit numbers show up multiple times in worksheet '2024' so I would need it to refer to the proper date.

Schedule 4 Tracker - COPY.xlsx
	A	B	C	D	E	F	G	H	I
6127	2-Nov-24	2449				OSH	2-Nov-24		1-Nov-24
6128		2453				STVL	2-Nov-24
6129		2488				SRK	2-Nov-24
6130		2490				EG	2-Nov-24
6131		2491					2-Nov-24
6132		2529					2-Nov-24
6133		2550					2-Nov-24
6134		2594					2-Nov-24
6135		8316					2-Nov-24
6136		8325					2-Nov-24
6137		8337					2-Nov-24
6138		8407					2-Nov-24
6139		8411					2-Nov-24
6140		8447					2-Nov-24
6141		8504					2-Nov-24
6142		0					2-Nov-24
6143		0					2-Nov-24
6144		0					2-Nov-24
6145		0					2-Nov-24
6146		0					2-Nov-24
2024

Cell Formulas
Range	Formula
A6127	A6127	=A6107+1
B6127:B6146	B6127	=(B5527)
G6127	G6127	=A6127
G6128	G6128	=A6127
G6129	G6129	=A6127
G6130	G6130	=A6127
G6131	G6131	=A6127
G6132	G6132	=A6127
G6133	G6133	=A6127
G6134	G6134	=A6127
G6135	G6135	=A6127
G6136	G6136	=A6127
G6137	G6137	=A6127
G6138	G6138	=A6127
G6139	G6139	=A6127
G6140	G6140	=A6127
G6141	G6141	=A6127
G6142	G6142	=A6127
G6143	G6143	=A6127
G6144	G6144	=A6127
G6145	G6145	=A6127
G6146	G6146	=A6127

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B7:B7326	Expression	=AND($L$1>=$G7, NOT(ISBLANK($I7)))	text	NO
B7:B7326	Expression	=AND($L$1>$G7, (ISBLANK($I7)))	text	NO
B7:B7326	Expression	=AND($L$1=$G7, (ISBLANK($I7)))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
H6127:I6146	List	='Current Month'!$AL$26:$AL$29

Thank you

 

[Simadri1986]

Cells with Conditional Formatting
Cell	Condition	Cell Format	Stop If True
B7:B7326	Expression	=AND($L$1>=$G7, NOT(ISBLANK($I7)))	text	NO
B7:B7326	Expression	=AND($L$1>$G7, (ISBLANK($I7)))	text	NO
B7:B7326	Expression	=AND($L$1=$G7, (ISBLANK($I7)))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
H6127:I6146	List	='Current Month'!$AL$26:$AL$ = =AND($L$1>=$G7, NOT(ISBLANK($I7))) [CODE=pq] [/CODE]