I'm making a db with 3 linked sheets, sheet K, sheet Y, sheet W to an
principal one P1.
These sheets will gonna get certain data from P1 when a condition of 3
chances is verifyed (K,Y,W), these data of that line are extracted to sheet
K, sheet Y, sheet W, depending on the condition that they have (represented
in the column C, table below).
What i want is to get the data by an a sequencial order of data in every
sheet K, Y, and W. To garantee that i'll only have these options i have a
validation list with only K, Y, W.
I'll gonna give example of what i want, with example of sheet K:
Sheet P1
A B C D E
1 12-05 Suplier K 10‚¬ 0
2 12-05 Suplier Y 0 5‚¬
3 13-05 Suplier K 0 15‚¬
4 13-05 Suplier W 7,5‚¬ 0
5 13-05 Suplier Y 8‚¬ 0
6 13-05 Suplier K 6 0
7 14-05 Suplier W 0 9‚¬

in Sheet K these data will be recorded:
Sheet K
A B D E
1 12-05 Suplier 10‚¬ 0
2 13-05 Suplier 0 15‚¬
2 13-05 Suplier 6‚¬ 0

Like it is in sheet K has to be in sheet Y and W.
How this can be done?

Thanks

P.S. I hope i have represented well and clear the question.