Excel function

Description of excel work: Create a sort function for a payments ledger
Extra notes: Accounts sheet only. See the raw data in rows 18 - 115. Currently i manually sort it into groups with the finished result looking like rows 118 - 133.

Once I press the function button the raw data will be deleted and i will be left with the sorted only.

Sorting will carry out the following;
1. Sort Column A groups first
2. Then sort into Column F
3. Provide one total each for the titles in Column F
4. Provide a total at the bottom of the newly sorted data
5. Give a total for each group in Column A

And one more thing from the previous job please; for the email text could a final line be added in brackets;
(This is a system generated email)