VBA novice needing help!!

Good morning everyone, I am new here and in desperate need of some advice.
I know very little about vba etc. so I apologise now for my ignorance!
I have posted a similar question on MrExcel and another similar site but struggling to comprehend hat I need to do... so anyway...

I have a master excel spreadsheet that will (eventually) be fed by almost 20 other workbooks that will be password protected.
How can I write a code on the master spreadsheet that will allow the passwords from the other sheets to be input rather than receive 20 password boxes?!

Thanks in advance
Iain

Cross-posted at:
https://www.mrexcel.com/forum/excel-...ord-entry.html
AND:
https://www.excelforum.com/excel-gen...ord-entry.html


Please read VBA Express' policy on Cross-Posting in rule 3: http://www.vbaexpress.com/forum/faq...._new_faq_item3

Now also cross-posted at: https://www.ozgrid.com/forum/forum/h...vant-workbooks

Evidently, you have no regard for this or any other board's rules. Account terminated.