hi busybee0279
You can start here (code example)
http://www.rondebruin.nl/copy2.htm
See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"busybee0279" wrote in message ...
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.