How do I link password protected files to a master spreadsheet?

Hi All.

I have a "master" file that several workbooks are linked to. Each individual workbook is password protected. I would like to be able to open and update the "master" file, however it is asking me for every individual password.

This is not ideal. Is there a way to include code in the master file that when i open this file as an administrator with password, it automatically opens each individual workbook without having me to type in each password?

Thank you.