Macro to show Which macro didnt work in a nested macro

Hi,
This time I have a different Problem and I am sure that you people can help me....

In the attached sheet, there are macros which will pull the data from the respective files allocated to it and update this master workbook.

I have updated a macro to do all those copy-pasting sheet by sheet.

What I need is, if the any of the macro fails, it should skip to other and in the end, it should tell me which are the macros failed without stopping the operation in the middle.

This is required to know that, which files are missing from the folder, so that I can take the followup of that, instead of searching everytime with the list.
New Consolidated MSR.zip