VBA to Save and Filter based on Column Value

[Andrew.Trevayne]

Hi everyone! Hope you are all safe and healthy!

I would like to ask for help on a spreadsheet to improve and reduce some manual process that I do on daily basis.
I have this spreadsheet that has tons of data (sometimes reaches to thousand lines), on column E will have values.
I would like to copy all the row if the value of column is the same and then, I would like to save them in a separate spreadsheet (at C:\Temp).

For example
All the rows that has value "AAAAA" in column E will be saved to C:\Temp as AAAAA.xls (and so on as long as the value in column E is unique).

Heading1	Heading2	Heading3	Heading4	MAIN	Heading5	Heading6	Heading7	Heading 8	Heading9	Heading10	Heading1
Pteuax Sextwzru	Active	ABC1	DEF1	AAAAA	XXXXXX1	Name1	LastName-A	Value	Value	Value	Value
arytexrzpxaa Szxrzv – qerpxe qaqqtuWzru_ypsaq	Active	ABC2	DEF2	AAAAA	XXXXXX2	Name2	LastName-A	Value	Value	Value	Value
Saqaqqtuwzru	Active	ABC3	DEF3	AAAAA	XXXXXX3	Name3	LastName-A	Value	Value	Value	Value
zuteazq qrzwavx Purxu Ptux-av / zqq-av	Active	ABC4	DEF4	AAAAA	XXXXXX4	Name4	LastName-A	Value	Value	Value	Value
Pytxev Sarapt xer vetupzq++	Active	ABC5	DEF5	AAAAA	XXXXXX5	Name5	LastName-A	Value	Value	Value	Value
Uvaty qax	Active	ABC6	DEF6	AAAAA	XXXXXX6	Name6	LastName-A	Value	Value	Value	Value
zqvzvtzxu/Uvavurszt zvztysas (Uz) Sextwzru	Active	ABC7	DEF7	AAAAA	XXXXXX7	Name7	LastName-A	Value	Value	Value	Value
Prexrzqzqer huruqav	Active	ABC8	DEF8	AAAAA	XXXXXX8	Name8	LastName-A	Value	Value	Value	Value

Appreciate if you could help me as I'm desperate, there are times that I have to save hundreds of file which is really time consuming.
Thank you very much in advance.