Help re-organising the data

Hello,
I uploaded my excel file-example that in Sheet1 has the columns ID,Date,Type,Name and Price. The data in these columns must be copied in Sheet2 but with different structure. The lines must be sorted according to ID number. Also every time a new entry is put in Sheet 1, the Sheet2 must be updated accordingly(in the correct position and structure).
Firstly, can it be done without macros and just using some given functions in sheet2? In this case the difficult thing will be the constant update of Sheet2 which troubles me..
Secondly, If macros and VBA programming are needed what would the code-subs-functions be??
I have some programming experience but none in office so i need to see if it can be done before I spend time trying to make it.Laslty it will be run on Office 2003.
Thank you in advance