Create single list of value from same cells across multiple sheets

[BigKeyes13K]

I have multiple sheets of an identical chart with different values for each week. I want to create a list of all these values on a separate sheet. An abbreviated example is below.

Washington County Weekly Active.xlsx
	A	B	C	D	E	F	G
1
2		Washington County
3		SCHOOL DISTRICT	ACTIVE	PEND	SOLD	AVG DOM	AVG SOLD $
4
5		ARGYLE	8	1	0	0	$0
6		CAMBRIDGE	11	1	0	0	$0
7		FORT ANN	3	1	0	0	$0
8		FORT EDWARD	1	0	1	7	$193,000
9		GRANVILLE	12	2	1	13	$120,000
10		GREENWICH	10	0	0	0	$0
11		HARTFORD	3	0	0	0	$0
12		HUDSON FALLS	21	2	0	0	$0
13		PUTNAM	4	1	0	0	$0
14		SALEM	16	0	0	0	$0
15		WHITEHALL	19	0	0	0	$0
16			108	8	2	10	$156,500
17
18		DATE RANGE:	1/14/2023 -		1/20/2023
14 Jan 23 - 20 Jan 23

Cell Formulas
Range	Formula
C5:E15	C5	=SUM(H5,K5,N5,Q5,T5,W5)
C16:E16	C16	=SUM(C5:C15)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F5:F15	Expression	=F5=INDEX(SORT(UNIQUE(FILTER(F$5:F$15,F$5:F$15<>0))),1)	text	NO
F5:F15	Expression	=F5=INDEX(SORT(UNIQUE(FILTER(F$5:F$15,F$5:F$15<>0))),2)	text	NO
G5:G15	Expression	=G5=INDEX(SORT(UNIQUE(FILTER(G$5:G$15,G$5:G$15<>0)),,-1),1)	text	NO
G5:G15	Expression	=G5=INDEX(SORT(UNIQUE(FILTER(G$5:G$15,G$5:G$15<>0)),,-1),2)	text	NO
D5:Y5	Expression	=SUM($D$5,$E$5)=0	text	NO
D6:Y6	Expression	=SUM($D$6,$E$6)=0	text	NO
D7:Y7	Expression	=SUM($D$7,$E$7)=0	text	NO
D8:Y8	Expression	=SUM($D$8,$E$8)=0	text	NO
D9:Y9	Expression	=SUM($D$9,$E$9)=0	text	NO
D10:Y10	Expression	=SUM($D$10,$E$10)=0	text	NO
D11:Y11	Expression	=SUM($D$11,$E$11)=0	text	NO
D12:Y12	Expression	=SUM($D$12,$E$12)=0	text	NO
D13:Y13	Expression	=SUM($D$13,$E$13)=0	text	NO
D14:Y14	Expression	=SUM($D$14,$E$14)=0	text	NO
D15:Y15	Expression	=SUM($D$15,$E$15)=0	text	NO
C5:C15	Expression	=C5=INDEX(SORT(UNIQUE(FILTER(C$5:C$15,C$5:C$15<>0)),,-1),1)	text	NO
D5:D15	Expression	=D5=INDEX(SORT(UNIQUE(FILTER(D$5:D$15,D$5:D$15<>0)),,-1),1)	text	NO
E5:E15	Expression	=E5=INDEX(SORT(UNIQUE(FILTER(E$5:E$15,E$5:E$15<>0)),,-1),1)	text	NO
C5:C15	Expression	=C5=INDEX(SORT(UNIQUE(FILTER(C$5:C$15,C$5:C$15<>0)),,-1),2)	text	NO
D5:D15	Expression	=D5=INDEX(SORT(UNIQUE(FILTER(D$5:D$15,D$5:D$15<>0)),,-1),2)	text	NO
E5:E15	Expression	=E5=INDEX(SORT(UNIQUE(FILTER(E$5:E$15,E$5:E$15<>0)),,-1),2)	text	NO

The values highlighted in purple are the values that I want in list, each in a separate column. Ideally it would look like this.

Washington County Weekly Active.xlsx
	A	B	C	D	E	F
1	Date	Active	Pending	Sold	DOM	Sold$
2	1/20/2023	108	8	2	10	$156,500
3	1/27/2023	110	1	8	68	$167,055
4	2/3/2023	108	7	6	37	$153,606
5	2/10/2023	107	11	4	28	$271,750
6	2/17/2023	109	6	6	9	$187,316
Sheet1

Column headers aren't important, I just added them for clarification. I add a new sheet every week. Ultimately I want to use this information to make a graph. I figure I need it all in one spot in order to do that. I also need it in date order. I plan to keep the sheets in date order so if that takes care of itself then I don't need to worry about it.

Help me pretty please, and thank you.

 

[fxjunction]

If you just want this as a cover page in the same workbook then you can reference cells from other sheets by putting in the sheetnameand ! before the cell reference. The example would be say in the last table you put as an example in cell B2 you would have =14 Jan 23 - 20 Jan 23!C16, that will put the C16 value from sheet 14 Jan 23 - 20 Jan 23 in B2 of the active sheet.

 

[BigKeyes13K]

I would have to constantly update that as I add sheets. It would actually be less work to manually enter all the numbers. I'm looking for something to do this automatically.