Combining multiple sheets to one list -excel

[SMBrenner]

Hello I am trying to combine multiple excel worksheets to one list using Alteryx.  I believe I need to use an Input Tool and a Dynamic input Tool to achieve this.  I have tried multiple time and have not been successful. Also, not sure the output goes since there is no output tool being used.    Any help would be appreciated as I am very much a novice.  I would also like to know how to do the same with multiple workbooks. 

Thanks in advance, 

Sue 

[binuacs]

@SMBrenner the below post might helpful for your use-case

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309