At EverSpark Interactive and H Creative Group we use Google Docs and Sheets to work simultaneously without having offline or duplicate files.
I needed to create a tracking sheet in Google Sheets that had a master page of data and sub pages of data for individual clients so I could show them only data related to them but I did not want to copy and paste. I wanted the sub pages to pull the data from the master when I updated data, thus eliminating a good amount of time. I found this post very helpful, he explains in order to do it you must use formula:
Note: The spreadsheet key is the URL of the page you want to pull data from, the range is a rectangle/square area of data you want to select.