This will display all errors at the end in a ListBox: New Consolidated MSR.zip

BTW: As far as I saw you are doing the same for each of the sheets, just the target file is different. Why then just write one sub with parameters source and target?