merge worksheets

[FHSAA_Dean]

I have a large spreadsheet with one primary worksheet that contains information about locations of alumni from our high school. Several class representatives have similar spreadsheets but may have different headers. I need to merge their spreadsheets into mine. Is there an easy way to do this?

 

[Legacy 143009]

You can achieve this by macro(aka VBA).