I have a 42 sheet workbook and I need to collect data from 18 of them.
The 18 sheets have varying amounts of data that is updated separately.
The data is to be pasted onto a summary sheet - called "Day by Day (2)".
The code should loop through all the sheets looking for those that have "update" in cell A1.
The issue I have encountered is that my code generates a Next without For error.
I am attaching my code - if anyone can spot my error I would be grateful.