Pulling data from different sheets to master sheet based on single identical column

Options

HI @Andrée Starå

I have a master project sheet, where individuals from 5 subspecialities complete the form (from master project sheet) whenever they have the new project. This sheet collects the basic information like project name, objectives, subspeciality, summary etc. Whenever the individual submits this form, they (Respective person who submits this form) will get an email alert with Project ID (which is autogenerated in "master project sheet" and they navigate to their subspecialty area within the Smartsheet to complete another form (which is specific for each subspeciality) and complete the form within that sheet on various aspects of the project like Institution, city, country (where project is taking place), project status, start date, end date . In my case, I have five subspecialities.

Within each subspeciality sheet I have used formulas to pull the data from master project sheet, whenever a row is added in the subspecialty sheet, based on '"Project ID". Therefore, the information from master project form and subspeciality form is under same roof (under subspeciality sheet). And this makes data to be pulled from master project sheets to all subspeciality sheets.

Know, I also need the information submitted in "subspeciality sheets" (which are five in my case) to be pulled into "master project sheet" (Project ID column can be connected). Right now, I am manually linking the cells every time whenever a new project is submitted, and wandering if there is any process to automate this step.

Simply, I have five different subspeciality sheet, the data from all these sheets should be pulled into one "master project sheet" (which already has Project ID and some basic information about the project). Can you please help me find a solution for this?

Answers