This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You'll first want to read in your Excel File to include the Full Path as a field and also only read in a list of sheet names.
The use a Formula tool to create updated FileNames that include the full path and the sheet name.
This will then be fed into a batch macro that will read in and combine all the tabs.
The macro itself is configured for the needs of the sample file you provided, so the template it uses starts the data import on row 9 but can be changed if needed. You can also include the Full Path or File Name as a field, so you know which tab the data is coming from.
Attached is a zipped copy of the sample workflow and the macro for you to try out.