Need Help in Excel?????

[Rahmatullah Ktk]

Assaalm-o-Alaikum Experts,
Experts, MS Excel me thori help chahiey. Attachment me excel ka aik screen capture diya ha. Mujy pochna ye ha k MS Excel me kam karty hoey jab ham koi list se summary tayar karty hain to is k liey hamain us list me se cells select karni parti ha, agar list choti hoti ha to koi masla nahi, agar list bari ho to hamain ye problem darpish aati ha k ham ne kon kon se list jama ki ha aur kon kon se baqi reh gaee ha. iska aik tariqa to ye ha k ham summary me formula k zariey dikin likin zyada waqt talab ha.
Kya koi aisa tariqa ha k jab ham koi b cell select karty hian aur wo automaticaly highlight ho jaey takeh hamain isy dobara se select nahi karna paray?
Please help me, its very good way.
Thanks