We have many (about 100) spreadsheets shared with 4 users. They contain a dropdown with part numbers. The list of part numbers needs to be updated monthly with more options. We want to do this without having to update all the spreadsheets individually, but have them update when opened.

I saw that I could have the dropdown list pull from another data source spreadsheet that is already open, but I assume that all users would have to open both spreadsheets to see the updated data.

Is there another way to do this?

For what it is worth: domain environment, all users on-site, Windows 10 & 11, Office 365.

Many thanks!
Brady