I am referencing to other excel files saved in the same folder. However, all
the excel files are password protected. Since the cells are all linked, the
master excel file which pulls all the data together, prompts me to enter in
every single password to all the different excel files I'm referencing to.

How can I bypass this?

Thanks so much for the help in advance. I appreciate it.