Call in the Cavalry - 2017

I'm stumped here. https://www.excelforum.com/excel-pro...worksheet.html

When I run the Macro from Aug 28 sheet it errors out when it attempts to look at the Aug 21 sheet. Each sheet is identified in the code loop. Take a look at the whole issue as I have added a couple of lines of code that are not in the original.

Thanks

Alan

EDIT: Solved.