Dumping a datasheet in folder and then have a master sheet to pick data out

[surkdidat]

What I would like to do is do a daily dump of data in a specified folder (format of name will be 20211115 (for today).

In the master sheet I will have all the workbook names in column A (the dates Monday-Friday every week).

In column B, C, D and E I want it to pull a count of "YES", from the respective columns in the daily dumps.


So, for today (for example) :-

Worksheet Name : 20211115	Column A	Column B	Column C	Column D
(Worksheet Header Names in Row1)	STAT A	STAT B	STAT C	STAT D
(Row 2)	YES	YES	YES	YES
(Row 3)	YES	YES	YES	NO
(Row 4)	YES	YES	NO	NO
(Row 5)	YES	YES	NO	NO
Row 6)	NO	NO	NO	NO
Row 7 (TOTAL)	4	4	2	1

Worksheet Name : 20211112	Column A	Column B	Column C	Column D
(Worksheet Header Names in Row1)	STAT A	STAT B	STAT C	STAT D
(Row 2)	YES	YES	YES	YES
(Row 3)	YES	YES	NO	NO
(Row 4)	YES	YES	NO	NO
(Row 5)	YES	NO	NO	NO
Row 6)	NO	NO	NO	NO
Row 7 (TOTAL)	4	3	1	1

etc

Then in the Master Spreadsheet

Worksheet Name : MASTER	Column A	Column B	Column C	Column D
(Worksheet Header Names in Row1)	STAT A	STAT B	STAT C	STAT D
20111115	4	4	2	1
20111112	4	3	1	1

I am figuring it will be a simple COUNTIF(.......,"YES") formula, but not sure how to reference the books (want to reference the cell, so I can add/remove data when required).

The formula will need to work with graphs (pie/donut charts/ bar/line graphs for the past 14/28 days.... I don't mind having a second table that references TODAY() and then and counts back (if that makes sense!)

Thanks, in advance, as always