If the "will of the people" is to have sodium thiopental injected into people, why don't the states in question build a plant of their own to manufacture the substance?
It's more a question of having a method codified into law than being stuck with that method. Instead of producing the drugs the states in question will probably just switch to another method of execution.