I have two sheets with data. The first sheet, which contains the source
information, has data in the range A1:A4 as follows:

Company A
Company B
Company C
Company D

The second sheet, which I want to link to data in sheet 1, will also have a
column A which links to the above data. However, I want to merge cells so
that Range A1:A3 are merged, and then link this cell to "Company A".
Thereafter, I would like to be able to copy and paste down and have the Range
A4:A6 contain "Company B", range A7:A9 contain "Company C", etc.

The problem is that when I copy from the merged cell (A1:A3 which is linked
to A1 on Sheet 1) and paste to the merged cell (A4:A6), instead of taking the
next sequential on sheet 1 (A2), it instead links to cell A4 ("Company D").
Any ideas on how I can adjust for this? Thx.