Yes, you can show records from multiple tables in a single interface page.
How you go about it depends on whether or not you want to see linked records.
If the records are not linked, you can have independent grid views, each with their own filters. I like to use a filter element for this. Note that filter elements are not as robust as the filters in a view.
If the records are linked, you can show a grid of linked record. Note that if you want to show records from two tables away, you would need a second record picker based on the previous linked record field.
Another technique I use is to use a multiple-collaborators field in the parent record, paired with a script that ensures that a given collaborator is only in a single parent record. The other tables have chained lookups of the multiple-collaborator field. In the interface, the child and grandchild tables are filtered to only show records where the lookup of the multiple-collaborator field includes the current user.