Not sure it's possible to automate easily since mailchimp is a rather simple esp. I might be mistaken though, it's been a while since I used them. You could probably solve it through the API or at least through a bit of recurring manual work.