Biggles,
I completely agree with your complaint that there are far too many clicks involved.
Please see my post here. I think that what I propose is emminently doable, would not introduce any real risk of error and would reduce the number of clicks by at least 90% - the exact number would depend on the mix of additions and updates that you make.
Alan