Creating a Macro to grab Data from multiple documents into one master document

Hello,


I am looking for some help about creating a macro that would grab specific data from 2 sheets in multiple workbooks and put them into one master sheet so that I can crunch some numbers on it.

I would like this macro to be able to grab all of the specific data from the 2 sheets from the entire folder that the data is in.

For example:

in the file listed as september, there are about 40 documents that I need to compile, the sheets that I need the information from are listed as: Patient 1 Output and Patient 2 Output


the data from those sheets are from C19 - J51

I would like that data taken from all of the workbooks in the september folder and just pasted into the master file all right underneath each other.

is this something possible that someone would be able to help me create?