Macro to open folder on desktop and certain files within

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!

mikeTRON:

Yes, there will be an undefined number of .CSV files, each individually in a subfolder, and all subfolders within the main folder: "Input"
Copy EACH into a new tab on a fresh/new workbook (the one I open to run the macro...).

I can't do one tab because the data has thousands and thousands of pieces of information per file- all in the same format. And I am looking for a certain thing from each one after I adjust it with another sub macro... however i've already done that one. The end game is to summarize all of the tabs in one summary tab so that I can export to Access. This tool is being developed to simplify our method of analyzing data for a complex process.

sorry for the long post. This is what I came up with to do what I need done. However, it won't actually paste into the new sheet in my original workbook. It opens the CSV file, selects the data, and copies the data, but doesnt paste.

Any thoughts?

Thanks alansidman, I apologize!

And I figured this one out! thanks