|Just looking for some clarification...|
So if there is a 3 (or Bob) in column H, and you change it to a 4 (or Sue), you want all rows that contain 4 (or Sue) in Column H to be moved to a new sheet named 4 (or Sue), correct?
You also want rows 1 - 3 to be copied to the new sheet everytime, right?
What if a sheet named 4 (or Sue) already exists? Is that a possibility, maybe after the sheet was created and then later another cell in Column H is changed to 4 (or Sue)?
What does the data in Column H actually look like? There are some characters that are not allowed to be used in sheet names. Is that going to be an issue?