Google Sheets Expert Needed for Data Integration

I am looking for a skilled Google Sheets expert to help me develop a straightforward solution that can streamline our daily turnover reporting.
I am looking for a skilled Google Sheets expert to help me develop a straightforward solution that can streamline our daily turnover reporting.

Project Requirements:
Automation: I need a program or script that enables daily data, sent in three sheets by my team, to be entered automatically into a weekly sheet, which in turn updates a yearly summary.
Efficiency: The solution should allow for simple daily data entry and automate the calculations across the weekly and yearly sheets.
Accuracy: The automated solution should ensure data flows accurately from daily to weekly and then yearly records.
If you have experience with Google Sheets automation, such as using Google Apps Script or relevant formulas, please get in touch. This is a straightforward project, but attention to detail is essential for accuracy in the data updates.