This is one of those moment where a macro recorder could really help. Try recording your steps one by one, while you do the minimum amount of click possible. The results should point you in the right direction. Just make sure you clean up the recorder results and don't use all of it in production.
How your knowledge of the API and VBA for example? How often do you have to make parts like this and with what variations?