Google Sheets Automations, Apps, Macro, Scripts, VBA

There are four google sheets.

I am looking for someone to use automation, apps, macro, scrips, VBA in Google Sheets.

This does not involve pork, music, pornography, alcohol, drugs, or profanity.

Timeline 7-10 days.

Estimated time to complete: approximately 3 hours

The tasks include
1. Sending out a basic email when a value is changed
2. Linking data from different sheets

There are 16 tasks.

Please see the attachments.