multiple tables

[yoanayy]

I am in the process of researching and finding a suitable university for me. I have created seven different tables from 2017-2023; each table contains information about the top 10 UK universities for the relevant year.
My question is, how can I make a new table that pulls the names of universities from the previous tables and get a new table with the top 10 between 2017-2023?

Thank you for your help!

[#2]

@yoanayy 

Assuming 2 Tables like:

and you run the most recent version of 365 (Please read Welcome to your Excel discussion space!)

=LET(
    stacked, VSTACK(Table1,Table2),
    sorted, SORT(stacked, 2, -1),
    TAKE(sorted, 10)
)