combinding many csv or xls files into one worksheet in Excel

[Strayrog]

Hi guys,

I am attempting to combind several (about 50) text comma seperated value files and have them show up on one singe Excel worksheet. I wrote a macro that created a new sheet for each .csv file but I can not figure out how to get them all on the same sheet.

Does any one have any ideas on how to go about this?

Thanks

Strayrog.