I have one workbook with two different worksheets

In other worksheet there is information what is old cost centre and what is
correspondin new cost centre and new name of that cost centre (cc):

old cc new cc new cc name
123 222 management
124 333 service
125 444 etc... phone costs

In other worksheet there is:

phonenumber old cc
0401234 123
0402345 124
0501234 125


And I need to get new cost centre number based on corresbonding cost centre
numbers in other worksheet and result is like this:

search term result of search term
phone number old cc new cc name of new cc
0401234 123 222 management
0402345 124 333 service
0501234 125 444 etc phone costs

How should I solve this thing? Is there a function to do that or do I need
visual basic. And plz I need a very strict answer about this...

Thx in advance and sorry my poor english!