Send daily email with tasks scheduled 'today' per contact list across multiple sheets

For transparency across our teams, I am hoping to send out a daily mail that includes all the tasks scheduled for that day from all active projects/sheets for each contact list .

Has anyone ventured into doing this? And if ever, what's the best way to get around this?