copy from different workbooks into one
 

I would like to be able to create a formula, or something, that will
automatically copy from a cell range in 5 different workbooks into one
workbook so I can reconcile the 5 new ones with the monthly summary. It will
be 5 different cell ranges coming together in one spreadsheet. These
workbooks are created by different people then sent to me.