Copy and paste certain data from source to destination file

[rizmomin]

Hello:

Please refer to attached files

I need a VB Code in MAIN.xls to perform the following task.

I have main file attached called "Main.xls", Source files and destination file (DEST.xls).
I am trying to sumarize payroll for employees in weekly (destination) file.

Location of Source file in cell D3
Location of Destination file in cell D4
MAIN.xls will have Start Date and End date in cell A4 and B4.

Example :

I have selected Start date as 1/5/2015 and End Date as 1/7/2015.
Corresponding source file names are in cell A5 and B5 in format (mmddyyyy.csv)
So in this case, basically there are 3 source files which needs to be open in the background.
In each of the source file, Look for text "Z1/Time Keeping" in column A.
Need to copy 3 columns of data from this row till the 1st text "REPORT END" to destination file
Data from 1/5/2015 paste in DEST.xls at cell A1
Data from 1/6/2015 paste in DEST.xls at cell D1
Data from 1/7/2015 paste in Dest.xls at Cell I1
I have attached all of the above files to understand.

Once all of the above is completed save the DEST.xls as file name shown in cell D5 of Main.xls

Please let me know if you have any questions.
Thanks.

Riz