Pull data from multiple password protected workbooks

[Caitlin535]

Hello again -

I have several individual password protected workbooks - one for each employee, each with a unique password - that collect that employees timekeeping data. I'm trying to make a master sheet that will pull data from each of these individual files into one master file for me (the supervisor). However, every workbook to which I link then requires me to enter that workbook's password when I open the master sheet. I do know all of the passwords (I made these sheets), so I'm wondering if there's a way to automate entering all the passwords so that the data will get pulled in without me having to enter every password every time (which rather defeats the purpose.

I found the following thread, which seems to have something *close* to what I need:
http://www.mrexcel.com/forum/excel-questions/168849-linking-password-protected-workbook.html

Near the end "TLA" remarks about pulling data from multiple workbooks, each with a different password, but then he/she doesn't really explain how to actually do it - or at least, not in a manner I understand. Might someone be able to translate/clarify for me?

Thanks!!