Combine multiple workbooks into one workbook

[Rookie_User]

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.