I have been working on a VBA project. This project currently consists of 4 files that can be accessed by anyone on a local network. The projects aim is to log issues with machines and hold a data base of all machines that have been fixed, while displaying all current unresolved issues on a monitor. The data path is as follows.
The file where the issues are logged has users open a user form where they fill in the relevant information. When the data is entered, and the user is satisfied the info is correct it is sent to the Masterfile. Here the data automatically goes into the last line of the On Going table/sheet. From here the people responsible for fixing the machine add the relevant information after completing the corrections and by a drop-down menu change the cell that says On Going to Resolved or Monitoring which sends the data to the top of its respective table/sheet.
The On Going sheet is also displayed on a monitor using an INDEX link. Currently between the Display file and the Masterfile I have an index link file. The reason for this is to allow the display to update automatically I had to have the Masterfile opening and closing repeatedly. As the Masterfile is a file that will have users I had to make a go between the two files, so the data is INDEX linked twice with the display file automatically opening and closing the Index Link file repeatedly to allow for automatic updates.
My issue comes when a user is using the issue log file while someone has the Masterfile open or are editing the master file on another PC. The data is lost from both files when they are both in use. If anyone has any relevantly simple suggestions to get around this issue I would greatly apricate your help. And apologies for my lack of correct terminology I am not a coder, and I am very new to VBA.

I had tried to use an Index link between the log issue file and the masterfile much like i had between the masterfile and the display but it does not allow for the movement of data from the on going sheet to the other sheets as well as I’m not even sure if it would have worked