Copy the data from this sheet to other sheet

Hello,

I have a problem about macro excel as:

I have the data in file excel:
Exam:
Vendor account Date Invoice Due date Amount currency Currency
FV01 24/10/2012 inv_test 23/12/2011 50,000 USD
FV02 01/02/2012 inv_test5 12/02/2012 60,000 USD
FV03 15/01/2011 inv_test3 15/01/2011 35,000 EUR
FV04 02/02/2010 inv_test1 20/11/2009 40,000 THB

I want to export the above excel to another sheet excel as:

Vendor account Date Invoice Due date USD EUR THB
FV01 24/10/2012 inv_test 23/12/2011 50,000
FV02 01/02/2012 inv_test5 12/02/2012 60,000
FV03 15/01/2011 inv_test3 15/01/2011 35,000
FV04 02/02/2010 inv_test1 20/11/2009 40,000
Total 110,000 35,000 40,000

Please help me as soon as possible. Thank you for your support .