How to quickly detect which files cause error in Excel writer and what error the files cause.

I face problem when combine about 20 xlsx files (assumingly has the same format of all columns and rows) using Excel Reader. Those files were taken from different people as they are supposed to provide some inputs into the files. sometimes the file owners made mistake by changing the format or forgot to delete extra column that they created. when I combine them, it shows error (red cross). I had to go through it one by one to find out which one and it is time consuming. is there a way to quickly detecting which files that cause the error and what error that it causes so I can go to the files directly and fix it?