Spreadsheet Automation for Gas Station Sales

I need help modifying my spreadsheet of accounts for a gas station. Currently, my daily sales data is organized in separate sheets for each day.

Requirements:
- Automate calculations for daily sales totals

Ideal Skills and Experience:
- Proficiency in spreadsheet software (e.g., Excel, Google Sheets)
- Experience with formulas and automation tools
- Ability to reorganize data from multiple sheets into a more manageable format