I have a sheet full of contact information similar to a mailing list. All of the information is in rows. I am trying to create labels (I am aware of mailmerge, but that won't do exactly what I need) in a new sheet. But when I do this, copy and paste the label so that I have several on one sheet, it skips several contacts.

So on one sheet I have: First | Last | Address | Phone | Emergency Contact | ETC
But on the labels I am trying to do:
First Last
Address
Phone
Emergency Contact
etc etc

But when I copy this down the page, it will skip from the contact in row 2 to the contact in row 12, then 22, etc. Is there anyway to easily solve this problem?

Thanks for the help in advance.