Centralizing rows assigned to individuals across multiple Workspaces

Randy Van Winkle
Randy Van Winkle ✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a project management workspace template that I create for each identical project (business startup).  There are a number of items that are assigned to a group of individuals by department (HR, Procurement, EHS etc.).  I used to keep all projects in one workspace and was able to create a report that would pull together all rows assigned to HR for example and new sheets that were created would automatically feed into the report.  Since I have moved each new project to its own workspace, I don't know how to pull those together so that the department owner does not have to drill into every sheet to find the one or two items that they are responsible for.   Do I have to manually add the new workspace to each report?