Move a Row to another Worksheet based on cell value (and remove row later)

So I know this is a common topic but I'm not advanced enough how to tweak this scenario for my needs and I'd like to learn how (so I can do it on the sheet attached and in the future!).

In the attached spreadsheet, you will see four Worksheets (Master Task List, 1, 2, & 3). Basically what I want to do is, if I enter either the number 1, 2, or 3 in column F (under "Transferred To") in the Master Task List, I want that entire row to be copied and pasted into the corresponding worksheet (e.g., if I type in "2" in the Column F of the Master Task List Worksheet, I want whatever is in Row A through E to be copied to Worksheet "2"). But I want to copy it to the next empty row (don't want it deleting data that is already there. Is it possible to automatically do this without having to press a button to run a macro every time (like putting the code in the worksheet itself?).

Also, once that is accomplished, I would also like for it to remove from the corresponding worksheet (1,2, or 3) if I eventually remove it from the Master Task List. Is that possible??

Thanks!

Master List Test.xlsx

Yes, if possible. Right when the number 1,2, or 3 (or whatever other numbers i eventually add) is entered into the cell. If that's not possible, then a button triggering it would be fine.

Thanks!!

---------- Post added at 01:51 PM ---------- Previous post was at 11:18 AM ----------

bumppppppp