Ok, I'll check this out. Thank you for the help. It's one of those
situations where I'm managing software license purchases, so for instance, if
the 2006 worksheet adds two licenses of a specific title, I want the summary
worksheet to automatically update and add two to the specific title. Will
the 3D function work for this?
Steve P.

"Ken Johnson" wrote:

Hi,
Search "Refer to the same cell or range on multiple sheets" in Help.
It clearly shows how to set up a 3D function so that changes are
automatically reflect in the Summary sheet
Ken Johnson