Let's be direct: the approach described here is working against itself, and the frustration is entirely avoidable. You have built a color-coded tracking sheet that tells project managers when insurance expires, which is smart. But the moment you have to manually pull COI files from a shared network drive, you have introduced the very bottleneck you were trying to eliminate. The spreadsheet becomes a rearview mirror instead of a dashboard.
The core problem is not Excel or SharePoint or the ACCORD 25 form. The problem is that your data and your documents live in two separate worlds, and you are the bridge between them. Every time someone uploads a new COI to a subfolder, you have to go find it, confirm it matches the subcontractor, update the expiration dates, and refresh the color coding. That process scales poorly. Add ten more subcontractors, and you add ten more manual steps. Add a hundred, and the sheet becomes a part-time job just to maintain.
What you need is a single source of truth that pulls the file metadata from the shared drive and syncs it with your SharePoint table automatically. Modern AI-native spreadsheet tools can watch a folder structure, read the file names or embedded metadata from each COI PDF, and update your tracking sheet in real time. No manual file hunting. No copy-paste errors. The sheet stays live because it is connected to the actual documents, not to a snapshot of them. This shifts your role from data janitor to data architect, which is where your time belongs.
The practical step is to evaluate whether your shared drive supports a simple API or webhook, or whether you can move those COI files into a SharePoint document library tied to the same site as your tracking sheet. If that is not possible, a lightweight script or low-code connector can watch the folder and push new files into your table. Either way, stop treating the network drive as a separate system. Integrate it. Your project managers do not need a spreadsheet that tells them what expired yesterday. They need one that tells them what will expire tomorrow, and that starts with automating the file pull.