Generating a formula in a cell re-iteratively?

Is there anyway using the newish functions (sorry I am an old version excel guy)
to trim this down into one line using LET/SEQUENCE/ etc

=VSTACK(
IF(BA2-(BA2-1)>BA2,HSTACK("","","","","","","",""),VSTACK(HSTACK("","","","",INDEX(AZ:AZ,BA2-(BA2-1)),INDEX(AY:AY,BA2-(BA2-1)),"",""),FILTER(AP:AW,(AW:AW=INDEX(AY:AY,BA2-(BA2-1)))*(AW:AW<>"")))),
IF(BA2-(BA2-2)>BA2,HSTACK("","","","","","","",""),VSTACK(HSTACK("","","","",INDEX(AZ:AZ,BA2-(BA2-2)),INDEX(AY:AY,BA2-(BA2-2)),"",""),FILTER(AP:AW,(AW:AW=INDEX(AY:AY,BA2-(BA2-2)))*(AW:AW<>""))))
)

it actually repeats 20 times I have just trimmed it to 2 iterations here

I appreciate any insight