WOW! Aren't you the analyst? If we do this, why would we need you to do your job?
WOW, all of those engineers and doctors and such, and you need to come to free forum to help?
What you are asking, if provided, I highly doubt you would be able to deploy, as it is very complex! I am not going to spend time WIRE FRAMING, and authoring a solution, only to have you say that it doesn't work.
We need for you to post some code, and if you get stuck, then you can ask for help.
Besides, have you unlocked the Developer tab in Excel? If not, start with that.
Have fun with that.