I need to take a worksheet with columns A1, B1, C1, D1 and reformat those
into rows. I am able to create the first set using basic =worksheet2!A1, but
I can't copy paste because it defaults to =worksheet2!A5 due to the
intervening rows.

Suggestions?