Thanks for code , but I would fix repeating same names files within subfolders as I said
important: could be there are files contains the same name but within subfolders so should rename first and when run again then should rename next (don't rename the same files names at once)
I should rename or change file have already named for the same files names should be one by one every time run the form , but the code will rename at once for all of same files names and I don't want it.
also if there is possible to show new file name in column A for adjacent cell for column B instead off add new rows.