Combining Tabs in one excel sheet

Hi I have multiple excel tabs in one Workbook which I would like to combine. This excel has over a 100 tabs which I would like to combine to sit under each other.

Is there any fast way to input the tabs quickly instead of connecting a new input each time for every different tab/sheet. Datasets Batch Macro

Thanks

Steve

Tips and Tricks

Batch Macro

Preparation

Accepted answers

fmvizcaino

Hi @sdinan002 ,

Take a look at the attached example. I'm using an input to get all sheet names and then using a batch macro to dynamically open all of them and concatenate one by one.

Best,

Fernando V.

2019-11-27 Combining Tabs in one excel sheet.yxmd

2019-11-27 multiple sheets example.xlsx

2019-11-27 one file at a time.yxmc

All comments

fmvizcaino

Hi @sdinan002 ,

Take a look at the attached example. I'm using an input to get all sheet names and then using a batch macro to dynamically open all of them and concatenate one by one.