I have approximately 40 Excel Files all to be updated by individual Users,
all password protected and accessible only to one user each.

I also have a "summary" workbook to be reviewed on a daily basis.

it is a big inconvenience to have to know and type 40 different user
passwords on a daily basis to have all links updated. Is there any way
arround that?

Thank you.