How to search a column by date in Google sheets, if it matches, then display the value?

Question

Google Sheets

Hello, please tell me how to reduce attendance from different tables and sort by date?
This is a dance studio CRM, there are n number of table files (by the number of halls), each has 2-3 sheets (by the number of groups) with attendance marks under the current date. It looks like this:

The halls have different work schedules, Tue-Thursday, Mon-Sat, Tue-Fri.
Task: automatically summarize the sum of visits from all halls in one table, under each date separately:

here is a link to the folder for tests

Answer 1

Here GLOOKUP (HLOOKUP) together with IMPORTRANGE can handle it Or immediately invite oshliaer update
to all questions about google tables : SUMIFS will also work on your data (instead of HLOOKUP)