I have a folder (on a network drive) which contains a number Excel
file which are all created from one single Excel template file. There
is a hidden Worksheet named "DATA" in each of these excel files.

I wanted to write code that would do the following:
1) From all the Excel files on the network drive select only those
that were modified today
2) From the selected Excel files, copy the values from Range (A1:A75)
on the "Data" worksheet of each selected file & paste these values to
a new file in column A (from A1:A75). Next, go to the second Excel
file in the folder that is modified today & copy range (A1:A75) values
from the Data Worksheet of the second file & paste them in Range
(B1:B75) of the new file.
3) .. and so, i.e. copy Range(A1:A75) from each of the excel files
modified today & place is sequentially in ranges (C1:C75), (D1:D75)
etc of the new file
4) Name and save this new file with the name "Batchfile" and place it
in the same folder.

Your help would be greatly appreciated.

TIA

Vinay