I have this workbook with hundreds of sheets.
Each sheet has some contract info at the top.
Then at B35 there is a list of invoices from that contract. By default, there are 20 rows available for the invoices list, so if there were ten invoices, there will be also ten blank rows and then a Totals row.
However, if there were 30 invoices for that contract, the person responsible will have added 10 extra rows, so all the 20 standard rows.plus 10 extra rows will have info, and then there will be the Totals row.
What I want is to go through each one of these hundreds of sheets in the workbook, copy the info between B35 and the Totals Row (but avoid copying the blank rows when there are less than 20 invoices) and paste it ALL on a single sheet, in a Database friendly format.