I am currently working on a monthly budget report with a master spreadsheet that is linked to over 100 other workbooks which contain each department seperately. The only way I can add or subtract a line to the master and have all the other workbooks update correctly is to open them all up before I add or subtract a line to the master. Is there an easier way to be able to add a line to the master without opeing them all up and still have the data continue to pull from the correct cells?