The Pitfall will always be there if that worksheet was deleted or even just renamed (external or internal)
So why not to check if a worksheet exists in an external workbook by it's codename and - if so - access the worksheet by its name?
So you check the worksheet exists and enum the...