Help! Macro for a Goal Seek Loop

Hi all,

I'm trying to build a macro that iteratively runs a goal seek, then reduces a certain value (Let's call it "Bogey") in a different cell by a small amount, which in turn affects the desired goal seek value, runs the goal seek again, reduces Bogey by a small amount again, etc etc, and keeps running in this loop, with the restriction on this loop being that a different cell, affected by Bogey--let's call it "Constraint"--doesn't drop below a certain amount.

I've attached an example spreadsheet to explain better. Essentially, what I'd like the macro to do is lower the Bogey value (cell E5) by a small amount, say 1%, then goal seek the "Goalseek Input" amount (cell E2) such that Goal (Cell E9) reaches 12%, and keep iterating until "Constraint" (cell E8) drops to 1.35%, at which point, stop the loop.