copying progressive functions

Hello;
I am using Excel 2010 and have created a budget. I have created a main BUDGET page with the enire year down one side and all my debts along the top (mortgage, rates etc).
I have also created multiple pages breaking down my budget per category (ie a page for utilites, a page for insurances etc) but each page also has the entire year down the left side and category along the top
NOTE: I have done this so I can track the date and time I make a payment for each debt along with the reference number I can refer back to.
clear as mud?
.
The question:
I would like to grab all the data from all the category pages and transfer the numbers onto one BUDGET page.
What I am doing is manually entering each formula for each categoy for the each day of the year. See below
- on the "BUDGET" page at cell C-1 I would like to grab the information from the "HOUSE" page at cell C-23 so I used the formula "=IF(House!C$1="","",House!C$23)"
- on the "BUDGET" page at cell C-2 I would like to grab the information from the "HOUSE" page at cell C-24 so I used the formula "=IF(House!C$2="","",House!C$24)"
- and so on
.
is there a way I can copy the formula all the way down the year without having to copy each cell individually and changing each number by hand? By my calculation I have to copy and change approx 6,570 times. I would prefer not to.
I think I have attached an example. I coded the first couple cells.

any suggestions?

thanks for the quick replies.

1) the example sheet does not match my real excel doc where I posted the functions from, sorry about that. in my example if you change the figure in HOUSE it changes it in BUDGET
2) i think I might not have explained myself properly or I am too new at excel to understand what you are saying :-)
.
what the main question is is this:
Q) is it possible, for example, to highlight all the cells and copy a function from one cell and copy it all the way down but have it change each new cell by + one?
example:
- at cell C-23 I used the formula "=IF(House!C$1="","",House!C$23)"
- at cell C-24 I used the formula "=IF(House!C$2="","",House!C$24)"

I am teaching myself Excel and try not to bother with questions but this one has me stumped. I googled for two days to no avail.

Thanks again.

You are indeed a champion. Thanks mate. I have been trying to figure this out for days. I hate asking for help. Thank you very much. :-)