Hi IrrepressibleXL,

For ease of practical solution, can you move all the required sheets from different workbooks to an single workbook so that LINKING may not cause issue. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>