Linking sheet 1 and sheet 2

Hi Paul

Thanks for the quick reply. Apologies, please find the sample workbook attached now.
Would be great if you had a solution for this.

thanks again.

alternative solution which negated this need was found