Here is the case:

Every week I will receive ten files(each has one work sheet) from my
brokers. All the files are in the same format but different size. Is there a
way to automatically collect the data from each file every week and put them
all in one work sheet?
The files name will change weekly(to accomodate the date) and so will the
size.

Thanks in advance.

Jason