I have a master sheet and within this I have a lot of links to other spreadsheets. When these spreadsheets update my master sheet updates but sometimes I have to open each sheet in order to update my mastersheet. Is there a button I can press to update the spreadsheets or how can it all be automated?

Thanks
Harry