Importing live data from a worksheet on another computer within network

Hello,

I'm looking for advice on the best way to pull live data from a spreadsheet on another computer within a local network. I have a spreadsheet that calculates and ranks input from 7 people (laid out as 7 columns with up to 37 rows depending on how many items must be ranked). Currently, the scores must be typed in manually but I would like to set up each person with a computer that can export their information to my master sheet, either automatically or on activating a macro when their data entry is complete. I've been experimenting with workbooks within a Homegroup but am either goofing something up or just on the wrong track because I can only get it to work when I'm using both workbooks on the same computer.

I've been researching like mad but can't seem to get this figured out. Can anyone point me in the right direction?