Multiple Files in a folder - Copying to one file

Hi

Glad to join, thanks for helping

I have a master folder containing files all dated for example december .(I would like code I could reuse in each months folder, if that is possible)

Each Sheet1 from each individual file , in this case 20 files , to be copied to a new separate worksheet (called master) that would list all the information from the 20 files on one sheet within the folder

It is strictly copying the data from the multiple files (all the same format) and pasting to one file

Does that help?