Move row to another sheet based on drop down selection, then move to another if same drop down cell changes.

[Pmarsden94]

Hi,

Tricky one for me to even work out....

I have a Google Sheet... with 6 tabs,

NEW COT DATA - CALL BACK - NO ANSWER - DEAL SIGNED - DEAD - ADMIN

When data is put into the first tab, NEW COT DATA, There is a prefilled drop down list called OUTCOMES in column "K".

If somebody changes this to CALL BACK, I want the whole row of data from A:K moved to tab "CALL BACK", but then if it is changed to "NO ANSWER", Moved from CALL BACK tab to NO ANSWER, an so on etc.

I have created this with test data here is a link to it. TEST DATA