Question: how do i import multiple csv files into multiple worksheets?
Answer: Start with a new blank workbook. Rather than File> Open use Data> Get External Data - Import Text File to import the first CSV file. Repeat the process for each of the other files specifying either Existing Sheet or New Sheet in the final step of the process.