Linking two spreadsheets

Hi,

I have a master document which includes training information for all employess. Currently, we have tabs for each employee (small company), which describes all of their daily/weekly tasks.

The problem is that you can't edit the file if someone else has it open.

We'd like to create an individual spreadsheet for each employee and still be able to display them in the master document. Is there a way to pull all the data from the individual spreadsheets into the master document? I know you can link individual cells from multiple documents, but because we don't know how big each person's document may be, we need to link the entire document.

Sorry if I'm not very clear, I'll answer any questions to try and clarify further.

We are using both Office 2000 and 2003, so it needs to be compatible with office/excel 2000

Thanks