VBA Code to delete the previous sum addition saved in summary sheet

Hello Friends,

My friend has made this code for me but since he is out of town for sometime I have stuck up at 2 areas. The attached sheet contain demo dump under sheet "Raw_Data" and once you click the Command button under sheet "Macro_Sheet", it prepare and saves sheet as per "Organisation name". Now the problem is:

1) In the summary sheet. total of various currencies is added under heading "Summary of Account" but once one sheet is prepared the summary data remains as it is and other countries currencies data are added above to it. I want the Summary of account should not contain currencies details carried forward.

2) The domicile country cell A2 picks the domicile country name from raw data but in case if there are more than 1 country name it should reflect the same as well, one below the other.

Please help me with the code at the earliest as I need to work on it tomorrow.

Many Thanks.

Can any VBA godfather help me? I thought expert over here are excellent and reply fast but this is the second time I am facing a problem and their is nobody who can help me.