Punters Club Spreadsheet - Data recording

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

The spreadsheet will need to capture all relevant information, such as money paid/banked, bets won/lost, profit/loss etc. Half money will be banked each week, half will be bet. Need to capture entire money saved also.
Sheet 1 – Dashboard to capture the following:
- $ Out
- $ In
- ROI %
- Total P/L
- Total Bank
- Expense tab – for money spent/withdrawn through the club
- Returns cumulative to date ($ and %)
- Returns by sport type ($ and %)
- Returns by person ($ and %) & Graph showing the $
- Indication of the bet with 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 2 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