VBA错误：运行时错误：9 - 从另一个工作簿复制工作表时下标超出范围

I am generating a new workbook from a multiple workbooks, i can generate a summary of all the errors found, but when i try to copy the sheets with the error information i got the runtime error 9I am generating a new workbook from a multiple