Goal seek entire column

The Excel goal seek function only lets you goal seek one cell at a time. I have 3 entire columns of cells I'd like to "goal seek", is it possible to do this with a macro? I've attached an example spreadsheet which shows how the data is organized.

Thanks