Hi there,
As a professional Excel developer, I will have no trouble putting this together for you within 24 hours. Not only will the sheet do what it needs to, I'll make it look good and professional.
I can set it up so that you just need to start typing a new line and the number will automatically be added and borders added automatically.
I would be happy to put the GRAND TOTAL at the bottom as you suggest, but many of my clients prefer to have it in a separate column at the top, so they can see it quickly even when they have more rows than fit on the first page - it's up to you!
If you have any questions, please get in touch. Hope to hear from you soon!
Iain