excel-macro.tutorialhorizon.com
VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
you want to combine many excel files into one file even when columns are not in same order.