Autofill Rows with data from other sheets

Hello! I am wanting to include a shortcut or widget on my personal dashboard that pulls in all of the rows from various sheets that I am assigned to. Is this possible? I thought that I may need to first create a sheet for all of those rows to populate and then include it in the dashboard, but I have not been able to figure out how to import those assigned rows.

Appreciate any help!