Need password for dropdown list in protected workbook

[abenny11]

Hello Excel Gods and Goddesses... I am new here and hope that i have not broken any rules.. But I am in desperate need of some assistance.
I have a set of password protected "sales forms".
I need to be able to have each "customer" enter a specific code to select their name from a drop down list so that only that user can see their respective discounts.
I have a drop down list created by data validation. (Cell B6) (data validation on Footnote tab)
I need to have it prompt the user for a password for each of the drop down selections (customers).
The dropdown calculates the respective discounts in cell F44.. But i dont want other customers to see other customers discounts. Hope that makes sense!
I have seen other posts but i am not familiar enough with VBA to edit them myself just yet.
I have attached an unlocked version of my spreadsheet.
ANY ASSISTANCE or guidance is super appreciated!