Hi all, wish you an early Happy New Year!

I am new to using VBA, looking for help to create a macro that can copy some specific .csv files from subfolders (there are subfolders within subfolders, below is the path I need to copy the files from) to a new folder.

Path: ..../A/B/C/D

A: multiple folders in this level, I need to loop through all
B: multiple folders in this level, I need to loop through all
C: multiple folder in this level but I only need to go into 1, so C is fixed
D: all the .csv files within C that I want to copy to a new folder on desktop

***Also, before I copy any .csv files to the new folder, I want to change its name from "D" to "A - B - D"***

Your help would be greatly appreciated! Thanks!