Trying to minimize a non-continuous function that depends on data-validation lists

Hi, thanks for the reply. I can't upload the whole thing, or even a working version, it's too big. Here's a copy of the control panel that I've used, but obviously it doesn't have any referencing to the other sheets. Hopefully you can get an idea of what is going on. The blue cells are the system configuration decision cells, while the red cells are outputs or parameters that are not intended to be changed during an optimization run.

I've considered recording a macro and just slogging through all the options, but there are quite a few. The problem is I'm quite a neophyte when it comes to VBA. That said, I'm by no means averse to learning more.