Question: how to import multiple csv files into excel on one worksheet?
Answer: Go to the Ablebits Data tab on the Excel ribbon and click the Consolidate Worksheets icon.
Select the CSV files you want to import in Excel. ... 
Choose how exactly you want to import the selected CSV files to Excel.