Returning Data

I have a workbook with 10 or more worksheets. At the end I would like to
have a list of the Employees there FTE and their location etc. My formula to
return the FTE works but I cannot seem to get the formula to return there
location. What I want it to do is look up the Employee's name and check what
their location is and return the data to that cell next to their name. Can
you help?

Worksheet 1 has the name of the employee in C3 and say Worksheet 5 has there
location in A1 and Worksheet 9 has there FTE in G5 I would like to have all
the data on one sheet for reports. All worksheet's will have there name. What
I am trying to do is combine it all on one spreadsheet. Each sheet will have
the Employee's name. It's like the 10 sheets is the Data Warehouse and I
would like to do a report from it.

Thanks


--
Newfie

Worked it out myself thanks.
--
Newfie


"Newfie809" wrote:

> I have a workbook with 10 or more worksheets. At the end I would like to
> have a list of the Employees there FTE and their location etc. My formula to
> return the FTE works but I cannot seem to get the formula to return there
> location. What I want it to do is look up the Employee's name and check what
> their location is and return the data to that cell next to their name. Can
> you help?
>
> Worksheet 1 has the name of the employee in C3 and say Worksheet 5 has there
> location in A1 and Worksheet 9 has there FTE in G5 I would like to have all
> the data on one sheet for reports. All worksheet's will have there name. What
> I am trying to do is combine it all on one spreadsheet. Each sheet will have
> the Employee's name. It's like the 10 sheets is the Data Warehouse and I
> would like to do a report from it.
>
> Thanks
>
>
> --
> Newfie