To get you started, you can use formulas to create what the password will be.
If A1 = NAME
A2 = ADDRESS
A3 = PHONE
the formula =LEFT(A1,2)&MID(A2,2,3)&RIGHT(A3,3) would produce the value NADDRONE
left(A1,2) = NA - Left 2 characters
MID(A2,2,3) = DDR - Middle 3 characters starting at the 2nd character
RIGHT(A3,3) = ONE - Right 3 characters
You can adjust that as required for whatever targets you wish.
Was that the end of your issue? or did you want to apply that password?
Assuming the latter... where... password to open sheet? Password to unlock sheet?
Please confirm