When I originally worked up the code for your question, I mistakenly thought
Column A had the M/V/G codes. After I noticed you actually said Column E, I
corrected my code. However, I missed changing 2 lines which could mean the
code won't work correctly if your row of data has nothing in Column A. Since
we know Column E must have something in it (either an M, V or G) and since
that column is copied into the other sheets, then using Column E would
guarantee the code would always work. Hence, you should use this corrected
subroutine instead...

Sub MoveRows()
 Dim X As Long
 Dim LastRow As Long
 Dim CellValue As String
 Dim SheetName As String
 For X = Worksheets("RawData").Cells(Rows.Count, "E"). _
                               End(xlUp).Row To 1 Step -1
   CellValue = Worksheets("RawData").Cells(X, "E").Value
   SheetName = Switch(CellValue = "M", "Mandatory", CellValue = "V", _
                      "Voluntary", CellValue = "G", "Global")
   With Worksheets(SheetName)
     LastRow = .Cells(Rows.Count, "E").End(xlUp).Row
     If Len(.Cells(LastRow, "E").Value) Then LastRow = LastRow + 1
     Worksheets("RawData").Cells(X, 1).EntireRow.Copy .Cells(LastRow, 1)
   End With
 Next
End Sub

Note: I removed the line that was deleting the data from the RawData sheet.

By the way, you do realize, if you leave the original data on the RawData
sheet, you can't just add new data to it, right? If you were to simply add
new data to the old data, then when you run my code again, the old data
would be recopied into the other sheets again (along with the new data).

Rick