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.