Macro to sort data into totals & %'s

I need some help with the enclosed file. The Data tab contains information on lorry journeys between locations, together with their departure and arrival times. This data is added to on a daily basis and therefore the total number of rows could increase to any amount. At the end of each week the Macro 'FormatFilterSortAndPasteToSheet' is run, which filters and sorts the data, so that all the movements associated with each 'letter' (column C) are listed together under each of the corresponding lettered tabs. What I now want to do for each 'lettered tab' is the following:

1/ Delete any entry in the HC column that starts with a '0' (this can be done before the
above Macro is run, if that helps).
2/ For each 'HC',the total number of times that 'HC' ran. ie 4E33 = 3.
3/ Of the total for each 'HC' how many arrived within 0-10 mins of booked arrival (column L)
ie 4E33 = 3.
4/ The above two figures as a %. ie 4E33 3 ran, 3 on time = 100%.

This information can appear in columns to the right of the existing data under the lettered tabs or on separate worksheet(s), whichever is easier. Any help is appreciated. Thanks Kevin.