Personal budget - add a number to a main category if i manualy add a number in a category

Hi, is there any way i can make so for example i have a new blank excel workbook with three pages in it.
Overview expenses and category

in category i will have a list

Daily life
10 Food
11 Dinner out
12 Annet
13
14
15
16
18
19

House
20 Rent
21 Electricity
22 Water
23 Mortage
24
25
26

Transport
30
31
32
33

and for example in my expenses sheet i have
Dato(date) Beskrivelse(reference) Ut/Inn(in/out) Kategori(category)
24.03.2014 narvesen -51

what i need is for example if i add number 12 in category section it will automatically add -51 to the Daily life section in sheet 1 (overview) and under correct month, so if the overview shows 12 months, this negative sum would be added to the March section.

In advance, thanks for any replies.

-Andreas

As you can see the first sheet includes the incomme and expenses,
Budsjett Andreas og Anette.xls
but on sheet two i want to organise the expenses, for example under different category
so if i take a bank transcript paste it into the row and then go over and set different categories
and it adds it to the correct date.
Colum A defines the date
Colum D defines the sum
Colum E defines the category the sum and date are to be included in the Overview sheet.