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.
Bookmarks