Merge multiple CSV files into one Excel File, but want them by tab by tab

[CHEUNGBKW]

So the situation is the following:

I have around over 100 CSV files, all have one tab individually. I would like to merge all of them into One Giant excel file, but all the tabs must be individually by themselves as they were before.

Please let me know as it will save ALOT of time.

Thanks!!!

 

[pbornemeier]

Are all of the files in the same directory?
Do they all have an extension of .csv?
Are they the only files in that directory?