Worksheet 1 : Contains information in numbers eg. 123456
Worksheet 2 : Contains information in numbers eg 123456 and belongs to James.

I need to add text eg 'James' next to that number eg.'123456' in Worksheet
1 and in a new column. The numbers may repeat within the worksheet 1.
Therefore, i need excel to run the selection and changes automatically.

How can i do that? What sort of formating or tools that i need to use?
Really appreciate if you could help me. Thank you in advance.