How to sort rows in sheet1 by using the predefined order of locations specified in sheet4

Hi All,

With below macro code I am able to create the report as shown in Sheet1.
Now I would like to continue the code with some more modifications,
All I want to do is - I would like to group the locations & insert few rows in sheet1 based on the order criteria shown in Sheet4 (Order shown in sheet1 is fixed).
So my final report should be present as shown in Sheet “Summary”.

Please help me with modifying the code.

Thank you in advance.

Please Login or Register  to view this content.

Please help me with code for above