Need Help w/ Code for Copy/Paste data for a Summary Worksheet

As a beginner at VBA, I'm trying to write a code that will copy data from several worksheets - within a range A14:T112 where blank rows are skipped- and paste into summary worksheet (with no blank rows).

Please upload your sample book. Go to advance, then attachment

Here's my Workbook...thanks for your help!

Thank you!
So, you do not have a summary sheet yet. Are all sheets in the book need to be consolidated? Do you want to exclude any sheet, except the summary which will be created by the code itself?

I do not know where the blank cells are, unless of course you want to shift all to the left. See the summary tab on the left which consolidated all sheets.

WOW!! This is exactly what I needed...and I think I can take it from here. Thanks so much!

Langie,
You are welcome!
Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.