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