How to merge rows that have similar location names

[aleanboy]

Hi All,

Please help me with this.

I have data of location & respective employee names in details sheet starting from row 6 till depends on day to day basis.
On clicking submit button, it should first sort by locations and then merge all the locations that are similar.
In short I need the final result as shown in sheet2,
but note: result should be in displayed details sheet only. That is merging & final output should be in details sheet only.
I have created Sheet2 just for your reference.

Kindly provide a macro code for this.