You can always just sum them together, you just need to be careful that data pull is lined up the same way every time.

In your attached example, the data begin on row 7 for Pull 1 and row 6 for Pull 2.

In the perfect world where you force the line to line up, it's a simple matter of repeating the given equation and just changing the tab references, and then also insulating them within IFERRORs to evaluate mismatches to zero.

B12:

=IFERROR(SUM(OFFSET('Pull 1'!$A$6,0,MATCH(Summary!$B$9,'Pull 1'!$B$3:$BG$3,0)+COLUMN(A1)-1,COUNTA('Pull 1'!A:A))),0)+IFERROR(SUM(OFFSET('Pull 2'!$A$6,0,MATCH(Summary!$B$9,'Pull 2'!$B$3:$BG$3,0)+COLUMN(A1)-1,COUNTA('Pull 2'!A:A))),0)

B13:

=IFERROR(SUM(OFFSET('Pull 1'!$A$7:$A$25,0,MATCH(Summary!$B$9,'Pull 1'!$B$3:$BG$3,0)+COLUMN(F1)-1)),0)+IFERROR(SUM(OFFSET('Pull 2'!$A$7:$A$25,0,MATCH(Summary!$B$9,'Pull 2'!$B$3:$BG$3,0)+COLUMN(F1)-1)),0)

And copy both over.


For a third, repeat the same process.

B12:

=IFERROR(SUM(OFFSET('Pull 1'!$A$6,0,MATCH(Summary!$B$9,'Pull 1'!$B$3:$BG$3,0)+COLUMN(A1)-1,COUNTA('Pull 1'!A:A))),0)+IFERROR(SUM(OFFSET('Pull 2'!$A$6,0,MATCH(Summary!$B$9,'Pull 2'!$B$3:$BG$3,0)+COLUMN(A1)-1,COUNTA('Pull 2'!A:A))),0)+IFERROR(SUM(OFFSET('Pull 3'!$A$6,0,MATCH(Summary!$B$9,'Pull 3'!$B$3:$BG$3,0)+COLUMN(A1)-1,COUNTA('Pull 3'!A:A))),0)