run report summary sheet for multiple tables

[sasuk]

Greetings all,

I have an excel workbook with around 20 sheets made of multiple tables, each table includes (participants name, location, language, attendance and a few other columns)

I want to create a run report button that shows a summary of all those tables in the workbook on that first sheet, with a hyperlink in the first column to each sheet in the workbook. Can I use vba to achieve this, or power query would be a better alternative for appending the tables and editing the source. (I am new to vba, but familiar with other programming languages)

can I make a button to generate the summary of these tables, and make it auto update whenever a new table is created with the same template, to avoid editing the source of the queries every time a new one is added.

[sasuk]

here is an example of the tables I'm working with