You are not listening to what Lisa says. Your code  is correct, but
misses the last part, where you actually paste  the information into the
Merge sheet.

So record a macro as Lisa suggested, and the answer will appear before
you.