Update Master Workbook

[ccameron]

Hi Guys,
I have a workbook that several people will use, what I want to do is create a master workbook called capital works, then have other workbooks the same but put the users initials after capital works. I would like to set up the master so that when user add data the master workbook will update the data. is this possible if so could someone please tell me how?

thanks in advance for any help it will be much appreciated.

Regards
ccameron

 

[ccameron]

Anyone?
A push in the right direction would be nice.