Refer to password protected workbooks

[jh]

I have about 30 workbooks that each have a password. Now
I need to do a summary that refers to each one of these
workbooks. But when these workbooks are referred to, I
am prompted each and every time for their passwords.

Is there anyway to do a macro that I can refer to the
workbooks by embedding the passwords in the macro?

So let's say here are my workbooks:

CombinedWS A2 = where I want the result to go (this is
the worksheet that will hold all the information that
comes from the password protected workbooks)

EE1WS A2 = the first worksheet that I want to refer to.
The password for this workbook is "1234".

EE2WS A2 = the second worksheet that I want to refer to.
The password for this workbook is "2345".

Thanks in advance for any help I can get.