PLEASE help with Excel links!

[starkey93]

I have several worksheets (1 to 5) which contain different quotations on each one by other colleagues. I want to create one spreadsheet (master) which has all 5 together on seperate tabs. However, the 5 worksheers are updated and added to daily. How do you put them all together on one worksheet so that they update when the original documents are added to and updated? So then we wouldnt have to copy and paste from the original spreadsheets to the master everytime. Do i need to use Macros to do this?

Hope this makes sense.
Any help would be muchly appreciated.
Thanks