Collect Data from different sheet to Master Sheet without naming sheet

Append Data from different worksheet to master sheet in excel

Create Multiple table of data in different or 1 sheet.

Go to Data, Get Data, Excel, and select respective file and click on import.

It will explore all table containing in this file, does not matter they are on 1 sheet or different sheet.

Check to select multiple table and click on load

Mouse Over on right side loaded table