Password assign user to get data from master files-excel vba

I Have enclosed workbook with Sheet of LoginPage,MASTER-DOMESTIC,MASTER-ONSITE,USERNAME'S
Result Enclosed workbook enclosed with result

I want assign all password to all partner'sname then if password is valid then open new sheet with column "G:G" data from "MASTER-DOMESTIC","MASTER-ONSITE"
with sheet name of what partner's Name logged in through Login Page?

See if One Partner is Digitech's password is "User115" if i enter password in login page then in no time Digitech data's in G Column From "MASTER-DOMESTIC","MASTER-ONSITE" with sheet name of what partner's Name logged in through Login Page. IN same workbook


Process> Login in Password > Split Multiple Values from column G:G of Two Master file> IN same workbook.

i hope you could understand

atleast i want assign all password to all user , make it done at your level of best.

I don't follow? You want the split the partner names? And how do you want the data to be parsed?