Combine 2 spilled range to one

A1# and E1# are spilled range, and I want to combine them to A7#. Number of row and column might change so you cannot hard code them. VBA is not allowed. Actually I can do this with Sequence()...