Extracting data from new files?

I would like to take data from 4 different files (each in their own respective directory) and put them into one excel file.

This needs to be done each day. There is 1 file per directory and it gets created each day. So each of these 4 file has a time stamp on it. Ex: LAB XXX-median-May-18-10.asc

Is it possible to have a new file updated with all of the data compiled from each of these four files into one new spreadsheet?

How would I go about making a macro for that?

Thank you in advance!!!!!!!!! I am very patient and I am not a programmer, but I am good at listening and am relatively computer literate.

OK, I was also not a programmer (not in VBA anyway) about 3 months back, but I was able to write a fairly complex macro, running into thousands of lines of code, by breaking down my project into tasks.

I started by googling "writing my first excel macro", and kept modifying that first macro per my requirements.

If you are willing to learn and write your own macro, folks in this forum can help you.

Here are the steps for you to start researching and get started:-
1. How to write a macro to open a file
a) given its name and directory location, or
b) by calling "Open File" method

2. How to write a macro to copy sheets from one file to another

You can start searching solution (code) for these steps - one at a time - and writing your own code. We are always here to help if you get stuck.

hth
All the best
Ajay

okay, thank you. i will take a look at some of this stuff over the next few days.

is there a specific command to open a file if it has a date in the file name?
ex:
this morning this file was created
LAB 221-median-May-19-10.asc

tomorrow this will be created
LAB 221-median-May-20-10.asc

is there a command so that my script will retrieve the data from only the file with today's date?

thanks!