I'm having a bit of trouble (OK, a lot of trouble) writing some code.
Here's my situation.

My Workbook has many Worksheets with names like L1-3, F2-6, L2-3, R4-10,
etc. I need to write code that will do the following: (I'll use a button
to execute this code)

For each sheet whose name starts with 'L', copy the contents of Range A8:D28
and O8:O28 to a worksheet called L_Summary, starting in row 3 and working
downwards. Blanks should be ignored, and each new set of data should be
appended to the data already existing.

I would be sooooo greatful for any help with this.
much thanks, Giselle