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




Updated on: 31/01/2023
Thank you!