Referencing password protected worksheets
 

I have some Excel files that are password protected. Now
I need to do a summary that refers to all of the
workbooks. I have run into a big problem!

The summary workbook asks for each password, one by one.
Is there a way I can refer to a worksheet without having
to put in the password each time?

Thanks in advance.