software

I'm making a db with 1 linked sheet (K), connected to an principal one (P1).
I want to do this:
When the word quot;Kquot; is tiped in P1, in row C, to copy that line to sheet K,
then when i tipe again the word quot;Kquot; in P1, in row C, i'll copy that line (or
just some data that i need of that line) for sheet K for line after the first
one. And then so on, and so on....
I make an example below.
If i wanted just the data with no order i could do in gain
=if('P1'!C2=quot;Kquot;;'P1'!D2;quot;quot;)
and in Lost
=if('P1'!C2=quot;Kquot;;'P1'!E2;quot;quot;)
But i want that in sheet K data appears all sequencially and by order, like
i show in example. The line 1,3 and 6, of sheet P1, appears in sheet K, in
line 1,2,3.

Sheet P1
A B C Gain Lost
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 14-05 Suplier Y 8€ 0
6 15-05 Suplier K 6 0
7 15-05 Suplier W 0 9€

in Sheet K these data will be recorded:
Sheet K
A B Gain Lost
1 12-05 Suplier 10€ 0
2 13-05 Suplier 0 15€
3 15-05 Suplier 6€ 0

How can i do this?