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.

Using Excel Power Query Combine Columns into Rows: Merge address data into a single column with line feed characters for better readability.

This month’s column shows how to clean and join data using Excel’s Power Query.