Sort by column E, and create sheets named by that column, add header and data

Hello there,
In the file "CODES_1", Sheet "Field Data" I'd like to sort data by column E (all possible cases) and create new sheets named by codes in that column.
-Add corresponding header from sheet "HEADER" to corresponding sheet name in the first row
-Add corresponding data into newly created sheets but without column E from Sheet "Field Data"

See file "COLUMN_2"

Thank you

Hi Mark,
Thank you so much, this is working so far. I added three more codes into "HEADERS" sheet and works well. Totally there will be some 30+ codes with headers and I hope it will work. The only thing I noticed (not) wrong was that "Field File" sheet gets unsorted if you look at the column A but I can do that manually.

Thanks again

Opss, sorry . Mike!

Hi Mike,
Yes this works but I noticed that program works only up to column G when you have a case where column H was completely empty (I had data after that column) and in that case program cuts off everything after that column.
What would you suggest?

Thanks

I just noticed that program will work only up to firs completely empty column. If you put something just in the first row it will work but again till next completely empty column