I do not know much about visual basic, but I have a spreadsheet that, in
column E, there are 5 different options. I would like to put these into 5
different worksheets, and then have a macro so that if the value changes, the
whole row automatically moves into the correct worksheet.

Does anyone know if this is possible and how it can be done?