Create dynamic calculated column for filtered list view

I have a SharePoint list of 20000 items, where each item has 11 different columns, with values (tags) as per the item, that I add manually.

So, I want to create a new column with a URL where the user can click and see a filtered view of all items associated with the same tags across the 11 columns that have been added historically.

I can create a filter for a few items manually but I need to repeat this process for 20 new items everyday, which is time consuming. I also want the filtered views for all historical list items.

Please help me write a conditional formula to achieve this.