How to find the values in all the cells from one sheet to other sheet and paste if found

Hi, i am having 2 worksheets where from sheet TRS under product colum there are values which needs to be found one by one in sheet AP and if found need to copy the value highlighted in yellow and paste in sheet TRS under column offshore file. Want to creat a loop for this search. I have attached the screenshot for the reference. It will be great help thank you.

Hi, i have attached the excel workbook. it has 2 sheets. the requirement is copy the product id from sheet TRS and search in sheet AP and if found copy the value present under that number highlighted in yellow and paste it in sheet TRS under offshore column. i want to loop this until the product id is finished using VBA.