Excel 2007 : link one worksheet to another

[SteveMoeDesign]

Sorry, semi-beginner here & not certain where to search. I have Worksheet A that has simple list of products in col A and quantities in col B with a total in lower right corner. This list expands and contracts (in rows only) over the life of the project. What I want to do is have a cell in Worksheet B show that total BUT ALSO be able to click on that cell and be taken to Worksheet A. I will likely have up to 50 worksheets like Worksheet A, but only 1 summary sheet like Worksheet B where they are all combined. Any help pointing me in the right direction would be helpful, thank you.