Automating Goal Seek using a value entry cell to calculate value in spreadsheet cell

[pbcollins54]

Hello. This is my first experience doing this...

I am trying to automate a Goal Seek Calculation as follows:

Goal Seek B24
To Value X (value for X is entered in cell B6)
By Changing B26

Obviously I can manually do this through the Goal Seek box, but I want to be able to enter specified value for X in cell B6 and have the process happen automatically every time I enter a value in B6.

Thank you.