Having written something similar with Visual Basic 6 a few years ago, I can write it's possible, but I know of no "click-here, here and there" solution. To be clear, I coded something similar, but you would have to be not adverse to buying the Visual Basic compiler and programming.

VBA might be possible, but I found it too restrictive and couldn't field a solution based on that.

Bob