Seeking Automation Solution for Linking Cells from Multiple Sheets to Master Sheet in Smartsheet


I'm looking for a way to streamline the process of linking cells from different sheets to a master sheet in Smartsheet. The master sheet, 'Project Dashboard,' contains 15 columns where linked cells need to be added. Each project has a unique 'Project Plan' sheet with identical formats but different dates. How can I automate this process to save time, especially as the number of projects increases?