Multiple Shared Worksheets to summarize

[smartpat19]

I have multiple shared workbooks that are each adjusted daily with updates and each of these files have a table that summaries(same headers for all) everyone assignments (this table does change as people leave the group and others are hired).

Need a file (master) that summaries everyone's workload. I wanted to make the summary table an excel table but with all these files being shared I can't do that.

I'm thinking that named ranges might be the way to go with some vba that would pull these values into the master file and then summarize from there? Can anyone think of a better solution?

thanks!
Pat

 

[RasGhul]

Something like this could work,

https://www.youtube.com/watch?v=wgCqFcylPQY&t=331s