Thread: Copy lines from variable sheet count

Hello,

I have a workbook with a number of sheets that increases monthly as new customer invoices get added to new sheets.
I have a DBase sheet that I want to pull info in from all the invoice sheets.
I need a code that will
a) count the number of qualifying sheets from sheet 3 onwards (sheet 1 and 2 is always the same
b) that will look at sheet 3 (first qualifying sheet) , copy all the qualifying data (ie copy the rows that has a code entry only Eg ASQL etc)
to the Dbase sheet and then look at sheet 4 , 5, 6 etc At the moment I only have 2 invoice/customer sheets

The attached workbook has:
Summary Sheet as sheet 1
D Base Sheet as sheet 2
and then all the individual customer sheets from 3 onwards.

At this stage I only want the Invoice line items to be copied into the DBase sheet.

Thank you very much!

Hi
try the macro in the attached file
Ravi