I have 10 different files in 1 folder. Each file has multiple worksheets and each worksheet is named. All the files have a worksheet named "Out". All the columns in this worksheet named "Out" are the same with different data in each column. I would like to see the VBA code for a macro that would take the data from the same worksheet in all the files and combine the data into one file.

Thanks,

Mike