Thanks newdoverman
My affiliate company has a server. Could this be linked through that ?
I will be having a master list that can extract data from each user's work sheet through dynamic links.
Also I can ensure that the data entered with a time stamp will be locked in their spread sheets as the date changes.
Interesting ?
Can I use sharepoint or google docs for this purpose ?