Help: need to make packing slips from excel sheet

Hi everyone!
I'm a total Excel newbie and I was hoping you could help me!
I have an excel sheet with some data containing customer's names, info... and their orders. Each column is one product, thus I do not have the totals for each order.
However I don't need them. I just need something to automate filling a packing slip template. With no monetary total, just one packing slip per Customer number that contains their info, address and their products ordered.
I'm attaching the lists with three rows as an example and the invoice template.
Please help!
Thank you so much.
LolaPacking Slip Template.docxinvoices example 1.xlsx

Hi XLAdept!
Looks good! I'm excited to see it working. Thank you so much.
Lola

Hi John!
Ok. I just fixed the excel document. I saw where the merged problem was! I apologize.
However I have a question: I made the same packing slip template in Excel. I don't need all of the columns in order to fill the fields in the packing slip. So how should I proceed? Should I delete those columns?
or just insert in those fields the example of the first order?
I apologize in advance if my questions are very basic... I'm just recently becoming familiar with Excel!
Thanks again.
Lola

Hi John,
Ok, here's the updated documents... let me know what you think.
Thank you so much!
Lola
invoices example Fixed.xlsx The table
Packing slip example FIXED.xlsx The packing slip for the first customer
Packing slip FIXED.xlsx The packing slip in Excel

THIS LOOKS AWESOME! ok so how do I run it, I have an invoice sheet with a lot more rows, I'd like to run the program on that!
Thanks!

Ok, so I'm trying to run this by copying your code, creating a macro and pasting it there. Is this correct?
Thanks!

Yes! I managed to make it run and it worked perfectly THANK YOU SO MUCH,
For the record, I did have to change a couple things, but they were my fault:
1. I had to change the ActiveSheet.Name = "PS " & N Because some of my customer's names were longer than what Excel allows for naming a sheet (I guess)
2. I had to check for some customers that had placed 2 different orders with the same name, because Excel does not allow sheets with the same name
Besides that... It runs like a charm.
THANK YOU!
Lola

@xladept One quick question... could we add the sizes?

Oh you guys are amazing! thank you XLADEPT! thank you John as well.
This is totally marked as solved.