I have 5 sales people and want to see there reports in 5 tabs on my personal spreadsheets. I am on a network. My spreadsheet is on the network.
How can I link their workbook to mine. the have a whole report.Do I have to link cell by cell or can i link their entire workbook page / tab in to one of my tabs?

Link 5 separate spreadsheets in one master sheet. ( I hope not cell by cell).