Complicated Macros Involving Filtering Columns

Hello there -

Well just to make things really complicated - I am not super familiar with Macros. I began tutoring myself yesterday, and I am now somewhat familiar with Loops, Ranges, Cells, and programming language generalities, but I do not know any specifics regarding language definitions (what words to use, when to avoid caps, etc.)

So here is what I'm trying to do. I have a spreadsheet detailing items that we are expecting on a construction site. My co-worker would like me to be able to filter these items by date.

The column headings involve Description, Equipment ID, Spec Section, etc (Row 9). The first column (1) has the description of these items. However, there are headings that appear every so often under Column 1. For example, I have "Air Handling Units" in cell 12A, and under that heading in cells 13A-25 I have the different Air Handling Unit Titles (Cluster S1, S2), etc. I've attached a screen shot so you can understand what I'm referring to.

So here is what I've been assigned to do, please don't laugh:

-filter the "expected on site" column by date so newest dates show up on top.
-when items falling under different categories inevitably get mixed together because the dates will align them in that way, I'm supposed to trigger a function which will repeat the headings each time an item from its category appears. For the purposes of demonstration, lets say that Cluster S2 under Air Handling Units was first, then 128" x 48" (Quantity 24) under Sound Attenuators, then Cluster N1 under Air Handling Units. So essentially I'm trying to get it to look like:

Air Handling Units
Cluster S2
Sound Attenuators
128" x 48" (Quantity 24)
Air Handling Units
Cluster N1

With their respective columns (Equip. ID, Expected on Site).

It is okay to not worry about major headings "HVAC." So long as I could figure out a way to do this complicated filter, I would be happy. I have already decided that making each of the groupings in the first column should be their own list,and made them so to keep linkage between that info and their headings. However I stop at the Macros. Any ideas? I ask you not to make fun of me. I am a quick learner and would appreciate any honest help.