ByPassing Passwords when pulling stats from external password-protected files

okay, brand new here... i just can't wrap my head around my problem; super hopeful that somebody can help me out here...

I have used excel to create a stat monitoring system to our work's employees. They enter their stats for the week, and I tablulate their stats for the manager's to review. There's only 50 employees in our non-profit organization. All of these stat files work perfectly.

So, now I'm at the point where I'm trying to create a manager file to review the performance stats of our employees. I'm trying to create a system that doesn't insist that each manager type in 50 passwords whenever they wanted an update on stats.

So, I have two worksheets.

One worksheet, called 'Passwords', shows the external file name [firstname_lastname_stats.xls] in A1 and their password in B1. This goes to A50 and B50 respectively. I have all of the external stat file names and their respective passwords in this file.

The other worksheet just pulls various stat totals already calculated from the external file.

How can I set this up so the manager doesn't have to type in all of these passwords? Any ideas? Thanks very much!