I have a workbook, with 13 sheets, 1st one named Summary, and the rest ProdLine1 to 12 representing production lines. The ProdLines contains various information on orders going through production. I need to find a way in VB to loop though all the ProdLines and check if an Order in Column A contains the word "InProd". If it has, then copy the entire row to the Summary sheet., and then loop through to the next order with “InProd” and copy that row to the Summary sheet, an so on through all the ProdLines.

Due to my inexperience of VB, I have spent a great deal of time trying to find a solution to this problem, but I hope someone out there will come to my rescue. Thanking you all in advance.