I have four little worksheets (one for each sales rep) that all have the same
data (ie. client name, date signed, sales amount, etc). I want to have a
"total" worksheet that will not only summarize all of the individual sales
persons data, but have the summary sheet automatically update when each
individual sales sheet is updated. I do not know how to use pivot tables,
macros, or consolidation. Please note that this office does not have MS
Access.