There is monthly confidential data I want to collect from my firm's subsidiaries through a SharePoint list, directly connected to my workfiles (Excel, Power Bi and related PPT). The existing SharePoint structure is well-made, with one library for each subsidiary, I and my fellow group controllers have access to all and subsidiaries' controllers cannot access each others'. The latter regularly use it to drag-and-drop or modify documents. On an additionnal SharePoint (created for testing purposes), I created a list that is well connected to my workfiles. All good until now.
I would now like to create the same list on my working SharePoint in order to enable subsidiaries to fill in their data every month (maybe upon reception of an automated email). I saw that one cannot duplicate a list in each subsidiairy's library cause they're not regular documents, so want to create a "masterlist" that would spread accross the SharePoint accordingly with the audience structure.
So I guess what I want to do is pre-filter it by library so that when the local (say British) financial controller opens its SharePoint library every first business day of the month, he can see the list appear and just has to fill it without seeing the rows the German controller has filled one hour earlier on his own library, etc. Failing that, I would like for all to access the same masterlist but certain items would obviously have to be blackened depending on who's watching.
That while keeping connection to my workfiles and not suppressing historical data. The leading SharePoint developer in my firm doesn't know how to do it though he told me to explore the Webpart path, which I did but hasn't helped yet. My developing skills are close to 0, but with clear instructions I can get help. Do you think it can be done ?