Totals based on Criteria

I have an excel workbook by which i generate a report as an output based on some criteria.
The output sheet is attached.
I have basically 2 prods: T & S
I need the system to first sort the Column 1 based on Name Ascending.
Then sort column D based on Oldest to newest.
Then merge the cells in "T" and "S" based on similar values in Column A.
After Merge is complete, sum qty the values in each merged cell based on Prod and Column "T" or "S".
Finally have a grand total.

Kindly help me with the same.