I did debugging your event code.
where is the target. from the validation arrow in sheet "summary 1 it looks it is in the column F which is column no.6
if you write target.offset(0,-6) this is error because it goes to the left of column A.I do not know whether you are thinking (0,-5)
(offset to step back or forwards)
in the immediate window if you type
?Target.Offset(, -5).Resize(, 5).Address
and hit enter key you will get
I think this what you are thinking
note offset is minus five and resize is +5(or +6)
you try with this modification.