A cell in a Source Sheet and link to Mutiple cells in a Destination Sheet

In my destination sheet, I want to link the values of a specific range of cells to A CELL in the source sheet. Is there quicker way to do the linkage? I tried to copy paste the format but the link does not apply to the rest of the cells.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!