Is there a way to click on a cell in one report and have it take me to another report?

edited 10/19/23 in Smartsheet Basics

I have one report which summarizes all items "drafting for fabrication" I would like to be able to click on a person assigned to this so that I can see what their whole job load looks like. Each person has a report but if I want to move around the priorities this would be helpful.