Harry Lee helped me with a macro very similar to the one I am now trying to put together. I get orders from 3 customers in .csv. I put these orders into their individual folders on my C drive. I am looking for a macro that will go look at all the .csv's in each of the 3 folders, then combine all the data on the .csv's into one worksheet. The .csv's have column headers. All the column headers for each customers .csv is the same, but one customer had a couple additional columns i don't need. You will see on the attached example. The attached example shows what the order looks like from each customer when sent to me. Instead of attaching 4 csv's, one for each of the 3 customers and the combine one, i just put 3 tabs, acting as 3 individual .csv's for my 3 customers. Then the 4th tab is how I am hoping it will look when all the orders in the 3 folders are combined. I made notes on the attached example as well. Thanks!!!