Bulk link cells from multiple sheets to master sheet

System

This discussion was created from comments split from: Seeking Automation Solution for Linking Cells from Multiple Sheets to Master Sheet in Smartsheet.

johanboth

I'm trying to simplify the process of linking cells from multiple sheets to a master sheet in Smartsheet. My master sheet, 'Project Dashboard,' has 15 columns where linked data needs to be pulled in. Each project has a separate 'Project Plan' sheet with the same structure but different dates. As the number of projects grows, automating this process would be a huge time saver. What’s the best way to achieve this efficiently?

Paul Newcome

@johanboth Do you have access to the premium add-on Control Center? This is exactly what it was designed for.