Consolidate data from multiple workbooks into 1 workbook

Originally Posted by arlu1201

Yes thats what i asked the code to do. Check in row 2 and populate the data. Is it not working when you tried again?

It is populating the data starting at row 2, but, it's pasting all data into column D so it's overwriting everything. I've attached a workbook so you can see the results of the macro. In this instance, I only had 2 files in my folder, so there should be one data set in column B, and another data set in column C. As you can see, currently everything is being sent to column D