There at least used to be an addon (called macro sequence or something like that) that would let you sequence macros like you would spells in a castsequence.
Try looking that up.