Unified framework for understanding pair transfer between collective states in atomic nuclei