Importing multiple CSV files into one excel worksheet (Mac Excel)

Hi,

Im all new to VBA, and I have been trying to figure out how to merge multiple CSV files onto one excel file.
I've consulted other help pages etc... but on success. I use a MS Office for MAC.

I have 23 separate CSV files with the same formatting

I want to:
1) Import the text data into excel (using the External Data text import tab)
2) The text should be imported in delimited form with the Japan (Mac OS) unicode as file origin
3) The delimiter is Comma only
4) I want each CSV FILE to correspond to a new worksheet (tab) and ideally the name of the tab should correspond to the CSV file.
5) There are a select columns which I want to delete which is universal across the CSV files

I appreciate all your help .

Thank You!

Thank You for your reply.

I get a "compile error user-defined type not defined" error...
Ill further investigate