Are the sheets in the same workbook or are you wanting to summarize totals in a new sheet in the same workbook?



You can create a reference to the other sheet something like this:
=[@Amount]*$D$3

Where @Amount is the header column name on my other worksheet in the same workbook and $D$3 is the percentage rate that I'm multiplying by to put on my summary sheet.

You can also complete a direct reference in your summary by type equal symbol switch over to your other worksheet and select the field you wish to display, such a totals for a particular column.

Example: ='March Individual'!I6 where March Individual is the name of the sheet and I6 is the field I selected to store on my summary worksheet. You can also do this from different workbooks, however I have never completed such a task and I would imagine the workbooks should be in the same location so as not to break the link.

As the values change on your main worksheet your summary sheet gets automatically updated.

Hope this might help your question.