Macro for arranging in descending order.

Hello All,

I am new to this forum (a little over than a week). Frankly speaking, i haven't seen an MS Excel VBA forum so active with all experienced individuals. I would require your assistance in writing a macro and would appreciate any help on it.

I have these three enclosed files which i update every week.Each of the three sheets include:

Row 1: Red highlighted area is for a new transaction and date at which it occurred.
Row 2: Description of the transaction (will always remain fixed)
Row 3: Details of the transaction (could go up to a maximum number of 10-15)

The challenge that i face is of arranging them in descending order (latest date transaction should appear first following the others) in a separate spreadsheet.

Please help..Thank you...