Would you be open to using Access, instead of Excel? What you are talking about sounds more "database" like.