Create a summary of different worksheets, leaving out empty cells, starting from row 12

Dear Excel-specialists,

I have a short question.
I have 1 master workbook that contains several worksheets, including a Summary worksheet.
The header for each worksheet is the same (from row 1:11). This also counts for the Summary sheet.

What I like to achieve is:
- walk through all worksheets in the workbook (could have different names) except the worksheet with the name "Summary"
- Copy all data that lives (per column A:Z) in all worksheets starting from row 12 until there is no data found
- Make a summary of all collected data, leaving empty cells out and put this in the summary worksheet also starting from row 12

Result: A summary of all the data from the worksheets starting from row 12.

My problem: The script gives not the desired result in the summary worksheet.
Column D stays empty (priority 3) and the word "Integration complexity" Cell H9 is also copied.

Can somebody help me out please?
Code an sheet is included.

Thank you in advance!

Best regards,

Hans

Please Login or Register  to view this content.

I think by now you should be able to come up with more informative thread titles: your title should explain what you are trying to do, not what's not working.

Hi AliGW,

Is this better :-)

Yes, thank you.

Hi NewBee_HS,

Try below code ...

Please Login or Register  to view this content.