Report Sharing

I would like to share a tasks report to my team every week. The goal is to have one sheet with the 'assigned to' filter on so that whomever is reviewing the report sees their tasks only. The problem is, I don't see a way to share the report reoccurringly in this format where it would bring the user to the SS Report instead of a PDF/Excel.

Is there a way to automate this or do I need to make separate reports for my team?