I need to look at the data in a particular cell then (employee name) compare
it to a list in another worksheet. When I find the match (employe names
match) I need to read the data in the next cell (office location).

Then I need to take that data (office location) and use it to tell the first
worksheet where to write the information beneath the original cell (it will
be a worksheet named the same as office location).

Any help would be appreciated.