Totals boxes either in footer or on separate page?

[Vaux_2]

Hi all, hoping someone can help me with my query as i'm not too sure what is possible and what isn't in respect of what i'm trying to do...

I'm creating a 'bill of materials' spreadsheet which allows me to track the amount of money spent in the course of a project for a client. Since every job is different the length of this list can be dramatically different.

As well as providing quick access to individual costs and part numbers etc it will provide totals to ensure budgets are adhered to. The spreadsheet is just basically a list of Qty x cost - discount = total with additional info for each line. Its the sum of all of these totals i'm struggling with.

In an ideal world i would just put 2 boxes in the footer, one for page total and one for worksheet column total, then it doesn't matter how many pages long the worksheet is.
Since i doubt this is possible how do i go about creating a different last page for the totals, keeping it in the same worksheet? Is it possible? I'm hoping that printing can be a 'one click' option rather than having to print off several sheets and same for inserting new pages if necessary. (people of different levels of skill with excel will be using this so simplicity of use is a must)

If the above is possible, how can i then setup the worksheet so that additional pages can be inserted with the same formatting and incremental line numbering (continuing from previous page) but so that i can still lock the worksheet so people don't fiddle with the doc.

I've already spent time looking around on the internet and had no joy in finding an answer so any help greatly appreciated. Even if the only info i get is what is possible, at least then i know what info i'm looking for to get it working.

Thanks,

Iain.