Sounds like scripting is the way to go, WF's are good but I'd normally avoid them for anything other than locking records / approval flow. YMMV