Hi

I have the following code that opens each individual password protected workbook that’s in a folder and combines the first sheet into 1 workbook, I currently have 20 workbooks that I am combining using an array loop.

HTML Code: 
This works great however I am soon having to combine 190 workbooks and I am thinking this code will be sluggish to loop around that many individual passwords.
I am thinking of having a separate sheet with passwords in column A and a direct path to each workbook in column B.

Would this be the best option and how would I amend this code to reflect this or is there a simpler way of doing this?

Apricate any help here

Thanks