select row in table and store the data to use it in another sheet of the report

Hi everyone,

I am making a report and what I need to do is select a row from the table on the home page and when clicking on the search button it redirects to another sheet of the report but keeping the selected value "project number" . the problem is that I can't find a way to store the data in the column "project number" so that the graphics on the next sheet are already filtered. I know that there is the data segmentation that manages to do this but I can't do it with the table. 

Best regards.