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