Dynamically populate summary sheet via hyperlink to data in another sheet

    Hi everyone, new to the community, I'd be v. grateful for any advice on this head-scratcher.  Not sure if I'm asking the question in the right way so please ask if anything unclear. I'm on a...