Excel Wage & Rent Automation Dashboard

I have a basic Excel file that tracks wages and rent payments, but it still relies on manual updates. I’m looking for someone to turn it into a streamlined workbook with simple automation and an at-a-glance dashboard.

What I already have
• Sample data that shows the columns and layout I’m using.
• A clear idea of the wage formula I need (hours worked × hourly rate).

What I need you to build
• An automated wage sheet that calculates pay instantly when I enter employee details and hours.
• A rent-payment tracker on a separate sheet that records each payment date, amount, and running balance.
• A summary dashboard that pulls the key numbers—total wages, total rent paid, and any outstanding amounts—into clean visuals and easy-to-read figures.
• Basic error checks (for example, highlight hours that exceed a normal range).

Deliverable
One Excel workbook that includes the wage calculator, rent tracker, and dashboard, ready for me to drop in my real data and start using right away.