I am trying to create a very large macro that covers alot of ground for a data analysis project. The first sub macro that I need to create is the following:

In a newly opened workbook, I want to run a macro that will open a folder on the desktop (of anyone's PC) called "Input". Inside "Inupt" will be a number of subfolders; I will call them "sub_1" "sub_2" "sub_3" ...... "sub_n" The number of subfolders, n, is undefined and will change each time I run the macro (conditional). Inside each subfolder will be a .csv file. I would like this macro to open each of the .csv files located within the subfolders within the main folder "Input". After all of the .csv files are open, I would like the macro to copy everything in each .csv file and paste into a different sheet in the originally opened excel workbook.

Any help would be greatly appreciated as I am very new to VBA based macro building.

Thanks!