A coherent modified Redfield theory for excitation energy transfer in molecular aggregates