Refernce other files and auto update info

[Riptide]

I need to create a master file which lists all projects an employee is
working on all in one tab. It also has to automatically update as the
employees enter their information in order to keep track of employees who
might be looking for work or not.

So I need in Master File cells from A1 to D6 reference a file from employee
#1.

Than in the master file have cells from A8 to D13 reference a file from
employee #2 and so on.

I know it can be done, but just don't know where to start.

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.