Is there a way to perform the same function as Goal Seek, but base the inputs
off of cells in a worksheet rather than actually having to click through the
menu and enter link to the cells each time?

Also, is there a way to have Goal Seek output the required figure to meet
your objective output without actually changing the input cell?