In a new worksheet you could use msquery to select the required columns from the first data sheet and do a "union all" with the equivalent columns in the second data sheet. This would give you a single worksheet or data array in the new work book (with all columns lined up) to do the pivot table on.