worksheets/workbooks in Excel 2000 and or Office2003
 

is there a way to make worksheets in other worksheets/workbooks and then have
all of that inside another workbook. I need to create worksheets for 3
employees to record their work individually, for example. The information is
entered into employee's worksheet then needs to be put into a separate form
that combines the employee's worksheets collectively for a month's period.
That then needs to be put into a form grouped by year. Is this possible to
do or am I wishing for miracles???

Any help is greatly appreciated.