I am trying to follow hyperlink to autofilter but I cannot

I have one worksheet named "stores" that has a list of store numbers (column A) and a second worksheet named "tickets" that contains a list of all store issues but in order to filter the issues to one store I would need to filter column P (as this is where the numbers are displayed on the second worksheet). I have converted all of the store numbers in column A to hyperlinks that go to the Tickets worksheet column P1. Which works fine, I would like to be able to click the hyperlink on the stores worksheet and it autofilter the tickets worksheet to only see tickets related to this store.

I have racked my brain for 2 days reading up on VBA and using google to accomplish this. I have tried to record a macro but when I run the macro it always filters to the store that I created the macro for. This is the macro I created:

Sub Macro2()
    ActiveCell.Select
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    ActiveCell.Columns("A:A").EntireColumn.Select
    Selection.AutoFilter
    ActiveSheet.Range("$P$1:$P$12840").AutoFilter Field:=1, Criteria1:="3557"
End Sub

I have been reading on the follow hyperlink method but I am dead in the water, I am a complete newbie when it comes to VB codes.

Any help is greatly appreciated.

Welcome to the forum.

Pls take some minutes to read forum rules and specially-in this case- rule#3