I have set up timesheets for my department. I have a template that I have
everyone use (About 10 people), This saves the worksheet as "CSTS Employee
number Date serial" For Example if Employee 432 created a workbook for this
week, the file saved would be "CSTS 432 38808.xls". They then mail me this
template every week.
I enter the data from their totals category into a master workbook which has
totals for everyone.
1.) Is there an easy way to pull all of these into this workbook for the
year?
I was going to use the date seial to pull the data into the appropiate
location and tab of the master file.
2.) Can I pull the data from the individule files without having to pull up
the worksheets?
3.) Is there a more eloquent way to do what I want to do?

Everyone uses Office 2003