Macro to import the same sheets names are repeated across files.

[Amer Omar]

Hello
I search for macro to imports sheets contain data from each any file ,some sheets names are repeated for more than file .
the files will be in this directory "C:\Users\AMROM\Desktop\REPORT"
so if this sheet name is MAIN and existed in two files then when add to MASTER file should be MAIN, MAIN_REPEATED1
if I have sheet name is MAIN for three files then will show in master file MAIN, MAIN_REPEATED1,MAIN_REPEATED2.
so should import sheet with the formatting and replace by delete sheets and add again to update data in MASTER file .
the MASTER file will be in the same directory , also the files will be within sub folders .
thanks.