Punters Club Spreadsheet - Data recording

I would like to have a spreadsheet created to manage a Punters Club.

The spreadsheet must capture all relevant information, such as money paid/banked, bets won/lost, profit/loss etc. Half the money will be banked each week, half will be bet. Need to capture the entire money saved also.
Sheet 1 – Dashboard to capture the following:
- £ Out
- £ In
- ROI %
- Total P/L
- Total Bank
- Deposits tab – to record weekly deposited amount for each member £
- Returns cumulative to date (£ and %)
- Returns by sport type (£ and %)
- Returns by person (£ and %) & Graph showing the £ (like a leaderboard)
- Indication of the bet with the highest odds that has won
- Indication of the bet with the lowest odds that has lost
- Summary data table with condition formatting (colours) to show the above information

Sheet 2
Bet Run Sheet:
Date, Punter, Sport, Stake, Odds, Results, Return, P/L etc.

Sheet 3
Data Input Sheet – To have the ability to manually add to sheet two selected columns at a later date as required – to add more sports, racetracks etc.

Sheet 4
Bonus Bet – Futures bet recording – much the same as sheet 2