Is there a way to directly link project-level SmartSheets into a master (summary) sheet?

Our team maintains project-level SmartSheets which we want to link to a master sheet for purposes of maintaining a consolidated sheet of all projects. Is there functionality in SmartSheets to link sub-sheet data into a master sheet that will also link drop-down lists from the sub-sheet? We have tried cell linking but the master sheet will not pull in drop down lists from the sub-sheet.

Answers