Hi Everyone,

I'm trying to write a code that copies the same ranges in all files in a folder(C:\Users\ple\Desktop\DTF-CRF) into a master workbook with column headers.
All of the excel files in the folder will contain a sheet named "Screening".
Cells K6 (Patient ID), K7 (Visit), C59 (Name), and P59 (Date) need to be copied from each workbook and pasted into their appropriate columns in the master workbook.
The columns in the master workbook are as followed:
A:A(Patient ID)
B:B(Visit)
C:C(Name)
D:D(Date)

There will also be other excel files added to this folder on a daily basis.

Any help is appreciated.

Regards,
Phil