Link multiple worksheets while extracting data
 

I am trying to create a system that will decrease the amount of times I need
to type information. I have a worksheet that keeps track of all tasks done by
an employee and for how long.

Ie. Employee File:
John
Hours Job Description etc...
1.5 Customer1 painting
4 Customer2 painting
2.5 Customer1 sanding

I only want to enter John's hours/job tasks once. I have a seperate workbook
designated for each Customer to assign the labour to their job. My problem is
that I want to set the Customer file up like so:

Customer1 File:
Employee Name Hours Cost
John 4 4hr*$$
Jane 2 2hr*$$
etc....

I have not been able to write an equation in the Customer File that will
search the employee files for the job (Customer1) and bring the corresponding
information from that row.
ie. Search John's File for Customer1 and enter Employee's Name in A2 plus
'hours' from the same row in B2.

As far as I know, Lookup, match, & index functions do not work. Please Help!!!

aj9000