I feel your pain. SharePoint tries to be all things to all people and as a result a lot of things seem half baked. Aggregating things across sites and/or lists is a common pain point.
I'm assuming that what you have is a number of different task lists that you need to monitor, and that you're looking for a purely end-user solution.
You could use Search for this. You should have a Search Center set up at
Enter a query for items where the Assigned To field is equal to your name, such as:
You should get a list of all tasks where that criteria is true. You will also get completed tasks, which maybe you don't want, in which case you'd add a condition where Task Status is not equal to Completed (the
<> is a "not equal" operator):
StatusOWSCHCS<>"Completed" AssignedTo:"Derek Gusoff"
We're using the names of SharePoint Managed Search properties, which you don't need to know, but it explains why the terms are as they are.
You might want to find all tasks with a certain status, say "In Progress":
StatusOWSCHCS:"In Progress" AssignedTo:"Derek Gusoff"
Finally, you might want to restrict your search to show only items with the Content Type of "Task" in case you have other types of lists out there:
StatusOWSCHCS:"In Progress" AssignedTo:"Derek Gusoff" ContentType:Task
The Search Center is incredibly useful for end users if you know how to use it:
NOTE: Search does not update in real time. Most of the time the indexes catch up within 15 minutes or so, but this being SharePoint...