I have a very large master spreadsheet with links to data in 5 other
spreadsheets. How can I avoid linking the cells one by one (from the master
to each of the 5), as I have noticed that copying a link formula does not
automatically update the cell reference? I am looking to save some time and
manual labor!