Iterative variational approach to finite many-body systems