Is there a way I can pull in multiple csv files and output them in 1 excel file, with each csv being in their own worksheet in the xls?
Yes. The best way to do this depends a bit on how many CSV files there (a few or hundreds) and how often you need to do it (once or frequently). Can you tell us a bit more?
If it is a relatively small amount to do, see:
Thanks, that worked perfectly