Difficult task: Creating a work monitoring dashboard

[dms11]

Good day,

For our next project we would like to use a master excel file (monitoring dashboard) that brings together all the information stored in 4 individual excel files in a cloud.
The 4 individual excel users should not see the master file (as they should not see each others work) but I would like the master file to be updated automatically. Basically the master file is a work monitoring file. The 4 workbooks are subsequently filled with furth data rows (columns stay put).

I am not sure which is the best way to make this work. As far as I am concerned I have two options:

1. Using Data Connections
Downside: I have to see each data connection manually if the user leaves the connected space

2. Using the merge tool of Excel
Note: I have never used it and do not know the pros/cons.

What would you recommend to do? Are there further options available?

Thanks a lot.

 

[sijpie]

If you do this with a macro, you can just open the file. You will then see what the user has done up to the last save (which may be different from what is on the user's screen).