Automatically transfering data after generating new worksheets

Hello,

It has been a while since I have worked with code and would appreciate any help.

I have one code already working which is gathering all my information and creating a tab for each unique input on my column E. I'm looking to run an additional code which will automatically gather all the row information on the cells with the same inputs in Column E.

SO far I have this code working for the tabs, I'm at a loss for the second action.

Sub CreateTabsFromAList()
Dim MyCell As Range, MyRange As Range
Dim DeleteSH As Boolean
Dim sh As Worksheet

Set MyRange = Sheets("invval_2").Range("E2")
Set MyRange = Range(MyRange, MyRange.End(xlDown))

For Each MyCell In MyRange
Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
For Each sh In Worksheets
If sh.Name = MyCell.Value Then DeleteSH = True
Next sh
If DeleteSH = True Then
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True
Else:
Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
End If
DeleteSH = False

Next MyCell

End Sub