VBA needed to convert multiple xls file to csv

Hi all,

I currently have a folder with c 60 seperate xls files which I need to merge into a single xls or xlsx file.
I have found a method of merging multiple csv files via a command prompt but need to convert the xls files to csv first.
Needless to say saving each one down individually would be very laborious so was hoping for a vba solution.
I have been trawling through the net but have had no luck.
It is worth noting that I am a VBA noob so please answer with that in mind

Of course, if you know a way of merging the files without the need for csv conversion that would be fantastic.

Thanks in advance.

PS. This is for work and I am unable to download any freeware applications.
PPS. I need to retain the original filenames for audit purposes.