REVIEW ARTICLE: Manifestations of Berry's phase in molecules and condensed matter