I am trying to copy data in a merged cell from workbook/worksheet to another
workbook/worksheet where the receiving cell may be a different location and
different size.

This is to be done via a VB macro because I will be doing multiple worksheets.