New Dynamic Table

[Pestomania]

I am trying to get a few formulas to work more effectively:

1. In Cell V1, I'd like a formula that says if Cell B1 shows '23, it creates 12 months of 2023. This would be dynamic so that when I add '29, it would add enough columns for 2029 and so on.
2. In Cell V2, I have a formula that was created on tis article (Distributed Row Results) that allows for static formulas, but I would like to try and get cell V26 to work where it uses vlookups and index/match to change the dynamic of the table.

Hopefully this all makes sense. I am open to any recommendations if there are easier and more efficient methods of doing this. The final table is going to be over 20,000 cells of data.

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE
1	Program	'23	'24	'25	'26	'27	'28								Batch Size							Jan '23	Feb '23	Mar '23	Apr '23	May '23	Jun '23	Jul '23	Aug '23	Sep '23	Oct '23	Nov '23	Dec '23	Jan '24	Feb '24	Mar '24	Apr '24	May '24	Jun '24	Jul '24	Aug '24	Sep '24	Oct '24	Nov '24	Dec '24	Jan '25	Feb '25	Mar '25	Apr '25	May '25	Jun '25	Jul '25	Aug '25	Sep '25	Oct '25	Nov '25	Dec '25
2	Program 1	80	52	52	60	88	32							Program 1	4						Program 1	4	8	8	4	8	8	4	8	8	4	8	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	4	4	4	4	4	4	4	4	8
3	Program 2	16	20	20	1	3	25							Program 2	1						Program 2	1	1	2	1	1	2	1	1	2	1	1	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2
4	Program 3	289	238	374	391	204	272							Program 3	17						Program 3	17	17	34	17	34	17	17	34	17	34	17	34	17	17	17	17	17	34	17	17	17	17	17	34	17	34	34	34	34	34	17	34	34	34	34	34
5	Program 4	16	22	18	14	42	44							Program 4	2						Program 4
6	Program 5	125	50	10	90	125	15							Program 5	5						Program 5
7	Program 6	105	105	15	165	360	240							Program 6	15						Program 6
8	Program 7	250	40	60	160	120	180							Program 7	10						Program 7
9	Program 8	35	98	35	63	21	35							Program 8	7						Program 8
10	Program 9	110	70	60	90	110	210							Program 9	10						Program 9
11	Program 10	8	144	144	120	48	176							Program 10	8						Program 10
12	Program 11	138	108	60	60	108	90							Program 11	6						Program 11
13	Program 12	152	32	104	144	168	80							Program 12	8						Program 12
14	Program 13	273	312	312	52	234	117							Program 13	13						Program 13
15	Program 14	210	105	180	15	120	165							Program 14	15						Program 14
16	Program 15	210	90	480	450	690	30							Program 15	30						Program 15
17	Program 16	216	180	108	144	153	216							Program 16	9						Program 16
18	Program 17	644	644	616	560	112	56							Program 17	28						Program 17
19	Program 18	180	18	288	126	126	306							Program 18	18						Program 18
20	Program 19	330	135	210	60	105	75							Program 19	15						Program 19
21	Program 20	80	60	140	140	130	200							Program 20	10						Program 20
22	Program 21	28	448	448	84	112	308							Program 21	28						Program 21
23	Program 22	648	81	513	27	675	108							Program 22	27						Program 22
24	Program 23	216	288	54	108	288	270							Program 23	18						Program 23
25	Program 24	176	286	528	154	110	374							Program 24	22						Program 24
26	Program 25	575	207	460	69	437	460							Program 25	23						Program 25	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
Sheet1

Cell Formulas
Range	Formula
W1:BE1	W1	=EOMONTH(V1,1)
U2:U26	U2	=UNIQUE(A2:A26)
V2:AG4	V2	=LET(z,B2/O2,b,SEQUENCE(1,12),c,z/12*b,d,INT(z/12)*SEQUENCE(1,12,1,0),e,MOD(c,1),f,IF(INDEX(e,b)<INDEX(e,b-1),d+1,d),f)*O2
AH2:AS4	AH2	=LET(z,C2/O2,b,SEQUENCE(1,12),c,z/12*b,d,INT(z/12)*SEQUENCE(1,12,1,0),e,MOD(c,1),f,IF(INDEX(e,b)<INDEX(e,b-1),d+1,d),f)*O2
AT2:BE4	AT2	=LET(z,D2/O2,b,SEQUENCE(1,12),c,z/12*b,d,INT(z/12)*SEQUENCE(1,12,1,0),e,MOD(c,1),f,IF(INDEX(e,b)<INDEX(e,b-1),d+1,d),f)*O2
V26:AG26	V26	=LET(z,(INDEX(Sheet1!$B$2:$G$26,MATCH(1,($U26=Sheet1!$A$2:$A$26)*("'"&RIGHT(YEAR(V$1),2)=Sheet1!$B$1:$G$1),0)))/VLOOKUP($U26,Sheet1!$N$1:$O$26,2,FALSE),b,SEQUENCE(1,12),c,z/12*b,d,INT(z/12)*SEQUENCE(1,12,1,0),e,MOD(c,1),f,IF(INDEX(e,b)<INDEX(e,b-1),d+1,d),f)*VLOOKUP($U26,Sheet1!$N$1:$O$26,2,FALSE)
Dynamic array formulas.

 

[Pestomania]

I was able to modify a let formula that was created before as well as work on a new date sequence formula that built the table I needed:

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS
1	Program	'23	'24	'25	'26	'27	'28								Batch Size							Jan '23	Feb '23	Mar '23	Apr '23	May '23	Jun '23	Jul '23	Aug '23	Sep '23	Oct '23	Nov '23	Dec '23	Jan '24	Feb '24	Mar '24	Apr '24	May '24	Jun '24	Jul '24	Aug '24	Sep '24	Oct '24	Nov '24	Dec '24
2	Program 1	80	52	52	60	88	32							Program 1	4						Program 1	4	8	8	4	8	8	4	8	8	4	8	8	4	4	4	4	4	4	4	4	4	4	4	8
3	Program 2	16	20	20	1	3	25							Program 2	1						Program 2	1	1	2	1	1	2	1	1	2	1	1	2	1	2	2	1	2	2	1	2	2	1	2	2
4	Program 3	289	238	374	391	204	272							Program 3	17						Program 3	17	17	34	17	34	17	17	34	17	34	17	34	17	17	17	17	17	34	17	17	17	17	17	34
5	Program 4	16	22	18	14	42	44							Program 4	2						Program 4	0	2	2	0	2	2	0	2	2	0	2	2	0	2	2	2	2	2	2	2	2	2	2	2
6	Program 5	125	50	10	90	125	15							Program 5	5						Program 5	10	10	10	10	10	10	10	10	10	10	10	15	0	5	5	5	5	5	0	5	5	5	5	5
7	Program 6	105	105	15	165	360	240							Program 6	15						Program 6	0	15	0	15	0	15	15	0	15	0	15	15	0	15	0	15	0	15	15	0	15	0	15	15
8	Program 7	250	40	60	160	120	180							Program 7	10						Program 7	20	20	20	20	20	20	20	20	20	20	20	30	0	0	10	0	0	10	0	0	10	0	0	10
9	Program 8	35	98	35	63	21	35							Program 8	7						Program 8	0	0	7	0	7	0	0	7	0	7	0	7	7	7	7	7	7	14	7	7	7	7	7	14
10	Program 9	110	70	60	90	110	210							Program 9	10						Program 9	0	10	10	10	10	10	10	10	10	10	10	10	0	10	0	10	0	10	10	0	10	0	10	10
11	Program 10	8	144	144	120	48	176							Program 10	8						Program 10	0	0	0	0	0	0	0	0	0	0	0	8	8	16	8	16	8	16	8	16	8	16	8	16
12	Program 11	138	108	60	60	108	90							Program 11	6						Program 11	6	12	12	12	12	12	12	12	12	12	12	12	6	12	6	12	6	12	6	12	6	12	6	12
13	Program 12	152	32	104	144	168	80							Program 12	8						Program 12	8	16	8	16	8	16	16	8	16	8	16	16	0	0	8	0	0	8	0	0	8	0	0	8
14	Program 13	273	312	312	52	234	117							Program 13	13						Program 13	13	26	26	26	13	26	26	26	13	26	26	26	26	26	26	26	26	26	26	26	26	26	26	26
15	Program 14	210	105	180	15	120	165							Program 14	15						Program 14	15	15	15	15	15	30	15	15	15	15	15	30	0	15	0	15	0	15	15	0	15	0	15	15
16	Program 15	210	90	480	450	690	30							Program 15	30						Program 15	0	30	0	30	0	30	30	0	30	0	30	30	0	0	0	30	0	0	0	30	0	0	0	30
17	Program 16	216	180	108	144	153	216							Program 16	9						Program 16	18	18	18	18	18	18	18	18	18	18	18	18	9	18	18	9	18	18	9	18	18	9	18	18
18	Program 17	644	644	616	560	112	56							Program 17	28						Program 17	28	56	56	56	56	56	56	56	56	56	56	56	28	56	56	56	56	56	56	56	56	56	56	56
19	Program 18	180	18	288	126	126	306							Program 18	18						Program 18	0	18	18	18	18	18	0	18	18	18	18	18	0	0	0	0	0	0	0	0	0	0	0	18
20	Program 19	330	135	210	60	105	75							Program 19	15						Program 19	15	30	30	30	30	30	15	30	30	30	30	30	0	15	15	15	0	15	15	15	0	15	15	15
21	Program 20	80	60	140	140	130	200							Program 20	10						Program 20	0	10	10	0	10	10	0	10	10	0	10	10	0	10	0	10	0	10	0	10	0	10	0	10
22	Program 21	28	448	448	84	112	308							Program 21	28						Program 21	0	0	0	0	0	0	0	0	0	0	0	28	28	28	56	28	28	56	28	28	56	28	28	56
23	Program 22	648	81	513	27	675	108							Program 22	27						Program 22	54	54	54	54	54	54	54	54	54	54	54	54	0	0	0	27	0	0	0	27	0	0	0	27
24	Program 23	216	288	54	108	288	270							Program 23	18						Program 23	18	18	18	18	18	18	18	18	18	18	18	18	18	18	36	18	18	36	18	18	36	18	18	36
25	Program 24	176	286	528	154	110	374							Program 24	22						Program 24	0	22	22	0	22	22	0	22	22	0	22	22	22	22	22	22	22	22	22	22	22	22	22	44
26	Program 25	575	207	460	69	437	460							Program 25	23						Program 25	46	46	46	46	46	46	46	46	46	46	46	69	0	23	23	23	0	23	23	23	0	23	23	23
Sheet1

Cell Formulas
Range	Formula
U2:U26	U2	=UNIQUE(A2:A26)
V1:CO1	V1	=TEXT(DATE("20"&RIGHT(B1,2),SEQUENCE(,12*COUNTIF(A1:G1,"<>'")-12),1),"mmm 'yy")
V2:AS26	V2	=INDEX(LET(z,SUMPRODUCT(($A$2:$A$26=$U2)*($B$1:$G$1=RIGHT(V$1,3))*$B$2:$G$26)/VLOOKUP($U2,$N$2:$O$26,2,FALSE),b,SEQUENCE(1,12),c,z/12*b,d,INT(z/12)*SEQUENCE(1,12,1,0),e,MOD(c,1),f,IF(INDEX(e,b)<INDEX(e,b-1),d+1,d),f)*VLOOKUP($U2,$N$2:$O$26,2,FALSE),MOD(SEQUENCE(1,12,0),12)+1)
Dynamic array formulas.