Oh wow!! Thank you so much; both macros work wonderfully and the code look much nicer than before! If you don't mind, I do have a few questions and comments as I was trying to learn from the code you posted.

Range("$A$1:$C$" & LastRow & ", $E$1:$F$" & LastRow & ", $L$1:$L$" & LastRow).
Ah, so that's how I can combine several columns into a range! I was looking all over trying to figure out how to do it.
How come the commas go inside the quotation marks? I tried to move them and I got an error. Is it because the '& 'connects the two strings together? (I'm still very new to the VBA syntax)

The copy and paste method is also really nice. Thank you for adding the comments. I came across the three lines of code that can help copy and paste ranges before, but I didn't know there was a short-hand for it.

Hmmm... I looked up intersect and UsedRange. I understand intersect now, but what does UsedRange do here?:
Intersect(.UsedRange, .Range("A:C,E:F,L:L")).Copy SummarySheet.Cells(NRow, 1)