I have a file containing several woksheets. Each worksheet pertains to a
specific aspect of healthcare (Doctor, Insurance, Pharmacy, etc.). There is
one final worksheet that is nothing more than a summary...which re-displays
the grand totals of each worksheet within this file. Here is the problem:

I have a column that names the family member who the item pertains to, and
on the summary worksheet I would like to gather the grand total for all
worksheets for each family member. It happens to be that all worksheets in
this fil has column "E" as the column that lists the name of the family
member. So...is there a formula that can gather all expendatures from all
worksheets in the file and total them up for me?

Thanks for any help!