The OFFSET() function may help you. Here you can also enter minus values with the 3rd parameter to create areas that have been shifted x columns to the left. With the 5th parameter you can then determine how many columns are selected.
Unfortunately, more information is missing for a more qualified answer. Maybe you can upload an example as a file here or at another filehoster. Then we can certainly help you better.