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