Workbook - Muliple sheets need totals on first sheet

[wisedave]

Hello,

I have a 2010 Excel spreadsheet that I need some help with. Basically it's a workbook that has several sheets. The first sheet has the totals from the other sheets. (See attached)

I need to add 4 additional sheets that all have their totals on the front page. The front page has a running total of the sum of all of the sheets. I would like the total to be more prominant under the logo in some sort of highlighted box.

The problem is this template was given to me and I can't seem to figure out how to make the totals work.

I have attached the template of what I currently use so you have a better idea. Also, if you have a better idea of how to make this **** ball look better, I'm up for it.

Thanks for any help or efforts!,

Dave