Given the basic programming ability of the folks using Excel, I would expect something more along the lines of BizTalk's orchestration designer or ChipWits.

and, yes I have spent the odd moment programming such a thing