I have twenty (20) .csv files which I am trying to load into a single workbook as 20 separate worksheet tabs with names "01", "02", "03"...etc. and then save it all as a single workbook of type .xls (not .csv)

I notice every time I click on the .csv file name it opens as a separate .csv Excel workbook - I have not found a way in Excel to 1) open a single new workbook, 2) load each .csv as a worksheet in that workbook and then save the new 20-worksheet workbook as a single .xls file. I have resorted to copy pasting the contents of each .csv file to a new worksheet tab twenty times - hence my desire for a macro!

I am an obvious newbie and grateful for any advice....