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