macro to copy in loop all sheets at specific row and paste in a new workbook

I have a workbook with several sheets which has same format and headers ,

The data starts at row 24 and headers at row 23.


I used the code below to copy but how to make a loop in all sheets and create a new workbook with sheet named summary.

Note that there is a hidden row in column B which I do not want to copy.

Please Login or Register  to view this content.

Hi Sintek

Works as charm perfectly

But insight from me ,my apology for this , on each sheet column A16 there is invoice no which looks like this FACTURE N° 186-2017-005C

Need to adjust code to insert a column in first column A of summary sheet as invoice header and to extract 186-2017-005C. which is always of 13 characters as per sheet from test fact .xlsx

JEAN1972

Try

Please Login or Register  to view this content.

Sintek & Jindon Thank you lot for assistance , both solution works a charm