what I need is a consolidate sheet where the data from the other two sheets will be consolidated but the columns which aren't comum to bth sheets still visible and filled with "0"

Consolidated sheet headers:
Column 1, Column 2, Column 3, Column 4, Column 5, Column 6, Column 7

Hope I explained what I want to achieve :-)