Combine multiple workbooks into one workbook
 

I would like to combine a number of workbooks inside a folder into one
workbook and maybe have the worksheet name be the name of the file or
something. The core issue is combining them. I have looked and I see how to
reverse it but not this exact thing, please help.