If you have multiple tables in separate Excel worksheets, providing they have the same column headers, you can use Power Query to stack the data into a single table.

Well-known functions like UNIQUE, COUNTIF, and SORTBY can be used with the spilled range operator to generate dynamic, sortable lists. Using a hash symbol (#)—also known as a spilled range ...