What is the fastest/easiest way to take data from one Excel sheet in columns A, B, C, ...etc. and load it in another sheet in order I, J, A, C, K, G etc (with some columns being left unused as they don't exist in the source sheet). I have ten of those workbooks in order of A, B, C ...etc. and need to bring them (after some column manipulation) into a single new workbook.

I am now thinking to copy and paste all ten of those workbooks into one, do the data manipulation (i.e. separating last name and first name etc) and then just cut and paste columns in the needed order. But I was hoping for an import that let me select where to map the columns.

Thanks,

HansM