I have created a master sheet for my workplace and this links to workbooks that will belong to certain staff. The idea is when they update some data on their sheet this syncs with the master sheet, along with everyone else's data making a complete total. The set up works for myself but the moment someone else accesses the same exact same files I am using to test it, it doesn't work. We have a shared drive that the files are placed in as well. I haven't changed the names of the files etc.