Formula For Calculating Sorted List Of Values

I am currently using a pivot to return and populate the required data but this does not refresh correctly and returns zero values every time this report is refreshed. I am therefore hoping that there is a way to calculate this using formulas .

The following applies:
The attached document has 2 tabs: Date AND Report
The Data tab feeds the report tab
The REPORT tab has 2 reports in it but doing the first one then I should be able to do the second one. If you look at the first table you will see the data that needs to be populated. I have added a highlighted (in YELLOW) row at the bottom of this table which shows you which columns populate what column

Requirement:
I am after something that will populate this table in a descending order - IE: the figures in the DATA tab Column BE should be sorted from highest to lowest. It must be filtered to the top 30 results only and then all the other columns must be populated.

Column H in the REPORT tab should be formatted to [h]:mm
Column F & G in the REPORT tab should be formatted to dd/mm/yyyy hh:mm