Hello tier.
just an idea..

if ever you could "shorten" the sheet names because this is also being used by the name range.. the we exceed the limit.

or maybe

divide the ranges

say
rangeA
==Sheet1!$B$5:$B$11,Sheet1!$C$5:$C$11,Sheet1!$D$5:$D$11...........

rangeB
=Sheet1!$E$5:$E$11,Sheet1!$F$5:$F$11,Sheet1!$G$5:$G$11,S..........

rangeAB
=(RangeA,RangeB)