Create folder and copy 2 sheets

[Conan]

Hello,

I would like to help me with the following problem:
In an excel file I have two spreadsheets, "Main" and "BC"​​. In sheet 1 (called Main) in cell C2 = Month and year in D2. I want to create a folder with the name of the D2, and a file with the name of the C2 here to copy Sheet "Main" and change its name to "Month Year" (C2 & D2), and then copy sheet BC with Name "BC Month Year". The same sheets that were created I want to be copied and the file where the code is released.

Ex. In sheet "Main" in C2 is May and in D2 = 2012. I want to create a folder named 2012 and here a file named May. This will create sheets "May2012" (which will be copied sheet Main) and "BC May2012" (which will copy the sheet BC).
The same sheets that were created I want to be copied and the file where the code is released.

Anticipated thanks to everyone who will help me.