How do I create a formula or Macro that will automatically collect entered data according to serial

Hello all,

How do I create a formula or Macro that will automatically collect entered data according to serial number, date & time, and description in order and place them chronologically at the bottom of the document? Also, is there a formula or IF factor I can add to a line that will allow a blank cell to clear out another cell in another location of the document?