Shorten an equation to create an automatic chart Help!

[Steph12]

Hi Guys,

I was wondering if I could shorten this equation but make it automatic.


So that I can update my chart automatically.

=(Masterbrief!$V$13,Masterbrief!$AI$13,Masterbrief!$AV$13,Masterbrief!$BI$13,Masterbrief!$BV$13,Masterbrief!$CI$13,Masterbrief!$CV$13,Masterbrief!$DI$13,Masterbrief!$DV$13,Masterbrief!$EI$13,Masterbrief!$EV$13,Masterbrief!$FI$13,Masterbrief!$FV$13,Masterbrief!$GI$13,Masterbrief!$GV$13,Masterbrief!$HI$13,Masterbrief!$HV$13,Masterbrief!$II$13,Masterbrief!$IV$13)


But every week I will update this.

Same for this equation

=(Masterbrief!$P$4,Masterbrief!$AC$4,Masterbrief!$AP$4,Masterbrief!$BC$4,Masterbrief!$BP$4,Masterbrief!$CC$4,Masterbrief!$CP$4,Masterbrief!$DC$4,Masterbrief!$DP$4,Masterbrief!$EC$4,Masterbrief!$EP$4,Masterbrief!$FC$4,Masterbrief!$FP$4,Masterbrief!$GC$4,Masterbrief!$GP$4,Masterbrief!$HC$4,Masterbrief!$HP$4,Masterbrief!$IC$4,Masterbrief!$IP$4,Masterbrief!$IC$4,Masterbrief!$IP$4)

The problem with shortening this equation is that the cells are merged.

Please help!