Hi Tesla,

Welcome to the forum.

I believe by using a dynamic name and with a support of Match function you can achieve the desired results.. upload a sample workbook in case of any issues. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>