Can a User click on a cell in one worksheet and be taken to another that is filtered?

Good day. I am not too advanced with Excel. I haven't used Macros or VBA but when googling my question, it suggested that may be the solution and when I tried, I couldn't figure it out.

I have 3 worksheets:

1. Data
2. Pivot: to sum the data and provide a VLOOKUP for Main
3. Main: a place for me to combine multiple Data worksheets

My goal is that when a User clicks on a cell in the Main worksheet, they are taken to the Data worksheet AND it is filtered based on criteria, in this case "Store Name".

I attached an image with the results I am hoping to achieve.

https://imgur.com/a/FKus2xB

Also, is there a way to skip the Pivot and have Main be able to SUM directly from Data?

Thank you for any help!