help me in coding for sumif formula

Hi John....

Its awesome and working fine.....

But i have multiple sheets in my original template which needs to be consolidate to the master sheet... sorry i didnt give this at the first instance... CC and order is common in all the sheets so in the column P if the Basic word is finished it should go to the next sheet based on the next text which is Conveyance.

please find the attached template for your reference.