Your first worksheet is called Sheet1 in my example, and the second
Sheet2

Sheet1 contains:
A B C
1 Cake 5 3
2 Coffee 2 7
3 Etc.
4

Sheet2 contains:
A B C
1 Coffee Eat Too
2 Cake Hot Drink
3 Etc.
4
In you second worksheet, first empty column  (Column D in my example)
Formula D1 = Vlookup(A1, "Sheet1"!A1:C50,2, False)

You will have to code  the formula properly, and ensure that the selected
range is correct when copying, as you are referring to the lookup range
on a different sheet.