Excel - Linked Workbook Passwords

I have a workbook that collates the information from 12 other workbooks but each workbook has a different password. Is there a way I can replace the formula in each cell (a grid of 105 cells) so that a vba function would call each workbook, open it with the required password automatically and update the cell in the laster workbook with the accumulative value?

i.e.

Cell B4 has =Sum(Workbook1!B4,Workbook2!B4,Workbook3!B4,Workbook4!B4...)
Cell C4 has =Sum(Workbook1!C4,Workbook2!C4,Workbook3!C4,Workbook4!C4...)

I hope this makes sense. If you need anything else, please let me know.

Kind regards,
Mav

Quote:

---

Is there a way I can replace the formula in each cell (a grid of 105 cells) so that a vba function would call each workbook, open it with the required password automatically

---

as you are referring to the workbooks multiple times, you could just open them all, then update the cells with formula then close all, rather than having to open all / many for each cell containing formula