Merge multiple worksheets from multiple Excel Workbooks into only one

[beatrizmguerreiro]

Hello, 

I have multiple workbooks, in 1 common directory. Each workbook has 1 worksheet named "Test_Data".

My goal is to merge all these worksheets into one final output Excel workbook. 

I tried to use a Dynamic Input Tool, but I can't seem to work with it.

Can somebody help me with this?

Thank you in advance. 

[JosephSerpis · Accepted solution]

Hi @beatrizmguerreiro this post might be helpful for you and has example workflow.