Remote access to workbook/ worksheet

[Adam Kelly]

From an excel novice;

Hi,

Using a spreadsheet to collect data from several PCs at different locations in the workplace - is there a way to have a workbook 'open' on a shared drive, where the seperate locations can input info onto their dedicated worksheet of the book? (such that the book updates with the new info automatically, and everone accessing the book can view the 'latest' info from all locations)

thanks in advance