I oversee a mix of residential and commercial rentals and want a single Excel file that lets me drop in my raw monthly spreadsheets and instantly see how the portfolio is doing. Core needs • A dynamic dashboard page that refreshes automatically when I paste or import new data each month. • Clear graphs and charts (no static tables) showing: - Occupancy Rate by property and in total - Maintenance Costs over time and versus budget - A high-level Income vs Expenses snapshot drawn from the same source sheets - Monitoring lease terms periods and options • Simple input area or Power Query connection so I can add a new month’s sheet without touching formulas. • Clean layout, colour-coded for quick scanning, and easy to expand if I buy more properties later. I’m happy with a straightforward solution—pivot tables, slicers, Power Query, or any other native Excel features—as long as the file stays lightweight and I can maintain it myself. Once complete, please walk me through how to refresh the data and tweak property lists, then hand over the unlocked workbook.