I know this should be simple and there are multiple examples of various versions of compiling data from multiple sheets to a summary sheet.
However, what I would like to do is simply copy the data from approximately 11 sheets to a summary sheet; I would like to add the name of each sheet in the last column (L) correlated with the copied data.
I have the code, but I’m not able to get it to run and when I do a compile in Visual Basic I get a “Compile Error – Next without For”. I have a For: “For Each sh In ThisWorkbook.Worksheets” so I’m not sure what I’m missing.
Please see attached example sheet to see the workbook and the code that I have.
Bookmarks