VSTACK values based on a selected date range

[rizzo93]

On sheet A I have columns containing names which are created using SPILL formulas. The header for each column is a date.

2/5/23	2/12/23	2/19/23	2/26/23	3/5/23
Petr Blincko	Avram Lukas	Erinna Fossord	Juana Cater	Forrest Spencers
Myrle Cossar	Ashlen Tremonte	Frayda Bottrill	Emlyn Limpenny	Ephraim Ganley
Thorsten Eastmead	Erhart Zanassi	Joanie Adrienne	Sharona Borgesio
	Ariadne Kilbourne		Joshuah Douberday

On sheet B I want to VSTACK these names according to a range of dates I specify. I want to do this by selecting the start and end dates off to the side somewhere on sheet B.

So if I want to stack the names from 2/12/23 to 2/26/23, I should get this:
Avram Lukas
Ashlen Tremonte
Erhart Zanassi
Ariadne Kilbourne
Erinna Fossord
Frayda Bottrill
Joanie Adrienne
Juana Cater
Emlyn Limpenny
Sharona Borgesio
Joshuah Douberday

I can VSTACK them, but I need help with how to implement the date range.

Any ideas, please?

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	05/02/2023	12/02/2023	19/02/2023	26/02/2023	05/03/2023
2	Petr Blincko	Avram Lukas	Erinna Fossord	Juana Cater	Forrest Spencers		12/02/2023	Avram Lukas
3	Myrle Cossar	Ashlen Tremonte	Frayda Bottrill	Emlyn Limpenny	Ephraim Ganley		26/02/2023	Ashlen Tremonte
4	Thorsten Eastmead	Erhart Zanassi	Joanie Adrienne	Sharona Borgesio				Erhart Zanassi
5		Ariadne Kilbourne		Joshuah Douberday				Ariadne Kilbourne
6								Erinna Fossord
7								Frayda Bottrill
8								Joanie Adrienne
9								Emlyn Limpenny
10								Sharona Borgesio
11								Joshuah Douberday
Lists

Cell Formulas
Range	Formula
A2:A4,C2:C4	A2	=N2:N4
B2:B5,D2:D5	B2	=O2:O5
E2:E3	E2	=R2:R3
H2:H11	H2	=TOCOL(IF((A1:E1>=G2)*(A1:E1<=G3)*(A2:E10<>""),A2:E10,1/0),3,1)
Dynamic array formulas.

 

[rizzo93]

Genius, Fluff! Works perfectly. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.