Theory of exciton-vibrational dynamics in molecular dimers