Returning Data to an empty Cell

[Newfie809]

Worksheet 1 is called All Staff
Worksheet 2 is called TEAM 1
Worksheet 3 is called TEAM 2

All Staff A B
C
LOCATION EMPLOYEE # EMPLOYEE NAME
1
JOHN SMITH
2
RAY SMITH

TEAM 1 A B
LOCATION EMPLOYEE NAME
DOWNTOWN OFFICE JOHN SMITH

TEAM 2 A B
LOCATION EMPLOYEE NAME
CENTRAL OFFICE RAY SMITH

I would like a formula to gather the location for each employee and return
it to the All Staff worksheet. Thank you

 

[Newfie809]

It's ok worked it out my self, thanks though.