I have to monitor staff attendance at mandatory training. There are 17 facilities that record the same data into spreadsheets, that is, Date of attendance & staff name - recorded in a table.
At the moment there is one table for each facility as different people enter the data.

I have looked into power queries, pivot tables etc but need some guidance on the best method to combine the data for reporting.

My aim is to minimise error during data entry and to be able to report on training numbers by date. Similar to a pivot chart and a slicer, I would love to be able to filter just by date range and have each facility numbers displayed in a table. The problem I have is that I'm unable to combine multiple tables which filter via one "slicer".

How can I dynamically combine all tables and filter via date ranges? Any help will be greatly appreciated. Thanks.