copy and paste based on criteria

hi all
I have a sheet were information is entered daily, there is a drop down box in column P, that users chose a reason, based on what they choose( in this case "other"), I would then like to copy the information from the rows where other was the cause, but only copying the data in columns P, Q, R, T, U AND V, this will be copied to sheet 2 from row 5 onwards, also as the information is entered daily, each time the button is pressed the information copied needs to overwrite any previous copies

many thanks if anyone can help

scouse13

thanks for the reply avk
the data structure is not the same, I would want range P, Q,R T, U, V ( IF P REASON IS "OTHER") BEING COPIED TO row 5 B, C,D,E,F,(B being "other" on sheet 2, and all other rows were reason is "other" copied to the next rows on sheet 2

scouse13