Master Project Link Help

edited 12/09/19 in Smartsheet Basics

I am trying to create a master sheet with certain information from 20+ other sheets. Each row of the master sheet will be specific to one project with various dates that need to be tracked shown in each column.


Is there a way to make each cell automatically know which project to pull information from without linking each individual cell back to the project it is pulling info from? Like a way for each row to know what project to pull from and each column to know what cell in that specific project to pull data form?


Sorry if this is confusing. Thanks!