the worksheets are named W1,W2,W3,W4,W5,W6,W7,W8,W9,W10,W12,WOET(WE).
The W1 sheet is the master sheet, I would like to copy the row data if coloum F has equals W2 onto W2 worksheet and onwards, IE if W1,F = W2 copy that row to worksheet W2 then look at next row.

Thanks again