Macro enabled workbook that looks for csv files in the current directory and imports them. One sheet per csv-file.
- Put workbook and csv-files in the same folder
- Enable Macros
- Run the ImportCSVs macro
- Enter the csv delimiter in the form that pops up
- Wait while processing
Done