I have a set of worksheets with different column headings. I want to merge all these worksheets into a single one with all the columns present from all the worksheets.

For example:

In Worksheet.1:
Col1,Col2,Col3

In Worksheet.2:
Col1,Col2,Col4

In Worksheet.3:
Col1,Col2,Col5

In Merged Worksheet, columns should be like:
Col1, Col2, Col3, Col4, Col5.

This is what i need to acheive through Macro in Excel2007.
Please post your comments/suggestions.

Thank you.