Can anyone suggest a method to combine all the csv files in a folder to one excel file with multiple sheets...

I can pass input folder,output folder, name of the new excel file
Number of sheets in the excel output file should be equal to the number of csv files and the name of each sheets should be equal to the name of the csv file.

I am a beginner with vbs. so any code examples would really help me....