Looking to import a number of CSV files into a single workbook, into individual and specific worksheets.
These CSV files will be located in a directory, say c:\user. In total, there are 8 csv files to be imported, in comma delimited format.
However, as there are 8 different files, each csv file is required to be imported into a pre-named worksheet within the workbook.
For example a csv file that CONTAINS the phrase "area 1", will be imported into the worksheet with the name "area 1".
Similarly, csv file that CONTAINS the phrase "area 2", will be imported into the worksheet with the name "area 2".......so on until "area 8".