Merging Data (Columns) Into another worksheet

Hello All,
So lately, I've been doing some macros. Nothing major. But this one I had used before and it works perfectly when I'm merging worksheets into a new workbook but I'm not sure where is it or why is it that it's only merging up to a designated area and not the range given.
Can someone help?
Basically, it's taking invoices and aligning the range given but it stops when there is a blank space. Look at invoice# 10002

Thanks in advance.