add message box and rename the same sheet for all of closed files in the folder

Hi experts ,
here is code will pull all of data from all of files are existed in the same folder for sheet name is MATCH , so if there files don't contain MATCH sheet then will shows error subscript out of range in this line

Please Login or Register  to view this content.

. so what I want show message box" the sheet is not existed, do you want rename all of sheets in all closed file to MATCH sheet" and contains two choices if press ok , then will rename to MATCH sheet and pull data , if I press no then will just pull data for just files contains MATCH sheet.
last thing when rename sheet to MATCH sheet for closed files should search for the first sheet to rename to MATCH sheet and ignore the others files contain MATCH sheet .

Please Login or Register  to view this content.

I hope somebody has idea to do that
thanks