Google sheets project

Need to make a google sheet that communicates to other existing google sheets and then communicates to a different sheet that then automatically sends emails to customers based on dates.

I already have a sheet that sends birthday emails to customers based on birthdays.