Hi,

I am looking to consolidate two worksheets within the same workbook but the worksheets do have a couple of different column names, example:

Sheet 1
Column 1, Column 2, Column 5, Column 6, Column 7

Sheet 2
Column 1, Column 2, Column 3, Column 4, Column 7

As you can see Column 1, Column 2 and Column 7 are concurrent with both worksheets but the others aren't, so is there any VBA which could consolidate the data in the correct columns?

Any help is very much appreciated.

Kind regards,