Greetings and some help needed

Hi.

It's my first time here, since only now I needed some help in excell, and, to be honest, I'm killing myself here... only because just now I realized that I'm a noobie!

I have several doubts, but I don't want to be annoying, so I'll post them by themes.

What I'm trying to create it's somehow a "database" of online bets done and to do (soccer).

I'll have several spreadsheets, divided by countries.
In each sheet, I'll have this columns:
- Teams I'm betting;
- Date of the bet;
- Bet value;
- Result.

In a final sheet, I would like to have the sums of this all.

So, my first questions:

- Lets say I have 8 bets to be played on July, 21th.
- Is there a way to automatically make this dates be highlighted in this final sheet? Changing the colour, for example.
- Is there a way to automatically sum all the bets made on the the 21th?

Example: bets in 3 different sheets (sheet 1 - D8, D9 for the bets and C8 and C9 for the date; sheet 2 - E9, E10, E11 and E12 for the bets and D9:D12 for the date; sheet 3 - C7 and C8 for the bets and B7:B8 for the date), and I want to automatically return the value of these sum to the final one (lets say, sheet 10 - B3)

Sorry for my poor english and thanks.

Greetings,

Rui P.