Copy and Paste reqrued on same heading/title

[harinsh]

Hi All,

I'm looking for macro code to copy paste the data into different sheet. I would receive different files every time with same format but heading will not be in same column (but all columns will be there but not in order every time). My concern is how to copy the data which has unique heading and paste under same heading which is there in master sheet.

Example:
Data file:
Date Part# Customer # Name Segment

Data required in master file:
Date Customer # Name Part# Segment

I do receive around 20 to 50 files which will not contain the same order but in master data I need data in required format.....

Thanks