I have 400 individual .csv files that I would like to assemble into one spreadsheet, where the data from each csv file would go into an individual tab of the spreadsheet. Thus, the spreadsheet will end up with 400 different tabs. Is this possible to do by somehow extracting the data without having to open each individual csv file one by one and only then doing copy and paste? Just looking for the fastest way to get the job done.
PS: Here ares some more details, in case you may find them helpful:
Each csv file has historical data for a stock symbol, 7 columns by approximately 100 rows. The main spreadsheet will have a list of the 400 symbols in one of the tabs, in one column. What I'd like to be able to do is import all of the csv files into this spreadsheet and have a sub that first creates a tab for an individual stock symbol (the tab's name will be the stock symbol, like MSFT, YHOO, etc.) and then copies the data from a csv file of that stock (the csv file's name is the stock symbol, such as MSFT, or YHOO, etc.) into the appropriate tab.