How to collect data from other people spreadsheets

Hi i need to create a dashboard by getting the data from other people reports. Is that possible?