I need some help merging these two worksheets, can someone please help me.

Worksheet 1.xlsm
Worksheet 2.xlsm

What I need is from worksheet 1 the field "Link Code" to be placed in worksheet 2 under the proper name in ws1. Using the Merchant ID could be a reference point to compare.