I've about 30 excel files in a folder (folder name is Jazz) on the C: drive. I'm looking to write a macro that will import Column A from all the 30 files and bring it under the new file called Result.