I have a spreadsheet in which the data changes daily (As far as number of
rows in each section)

Basically the data I want to sort is in columns A through D

I need a Macro to sort based on Column C from Largest Number to Smallest
Number, and delete any rows in which the number in Column C is less than but
not equal to 5.

Then copy what is in Column B for each row to another spreadsheet and
transpose from the column form to a single row.

The catch is the information that needs to be sorted is in the middle of a
bunch of other data, so, I would guess I could use some sort of code to match
the number "0" in column D for each row to sort and copy...

Hope this makes sense, thank you for your help!