is there a VBA code that will accomplish the following requirement:

Whenever a number is entered in sheet1 ColumnA the VBA checks to see if the number is either 1 or 2 or 3. if the number is 1 then copy all the contents in the row and place them in the next available row in sheet2. if the number is 2 then copy all the contents in the row and place them in the next available row in sheet3. if the number is 3 then copy all the contents in the row and place them in the next available row in sheet4. Also, if i edit "any" of the values in sheet1 that were already copied to sheet2, or sheet3, sheet4, i want the edit to be reflected in the respective sheet. for example, if i edited the "last" value from sheet1 columnA, like change 1 to a 2, i want the last values(row) copied to sheet2 deleted and the correst values entered in sheet3.

Thanks in advance for your assistance.