Hi Tom,

Welcome to forum.

This seems to be achievable using dynamic name ranges / offset function etc, but it will be better if you can upload the sample file for the forum to give a try. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>