Theory of excitation transfer in coupled nanostructures – from quantum dots to light harvesting complexes