Consolidating data from multiple worksheets

I'm having trouble consolidating 2 spreadsheets that when the new "Master" is created, it only contains the header row, the first column and the 4th column.   I'm using the dialog box to create the...