Skip to Content
Communication Square LLC Help Center

Collect Data from different sheet to Master Sheet without naming sheet

Written September 2022. Microsoft changes these admin screens often, so the screenshots below may not match what you see today. The sequence of steps is usually still correct — if something looks wrong, tell us and we'll update it.

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

Last updated on

Related articles