Going to try explain

i have 1 excel file with 2 sheet

In the first sheet i only have 1 colom with 100 ticketnr's and in the other
sheet i have the sameticketnr's but also from other countries with more data
f.e. users name,comment's,....

What i want to do is that a "macro/... checked if a ticketnr from sheet 1
excists in sheet 2 and if it is that all users data is copieed from sheet 2
to sheet 1. Is this possible ? And if i can f.e. only copy 3 cell's rom sheet
2 to sheet 1, so not all data