Is there a way to make a Company Wide Directory that can be used on other sheets?

So when you make a form, you can have conditions based on specific entries. Make all the names in the employee column a part of a dropdown or contact list. Do the same for the Supervisor and Manager column. Go into your form and select the Employee field. Once there, you will see field and logic on the right hand side. Just click logic and set it to populate the manager and supervisor fields based on which employee is selected. Make the manager and supervisor fields hidden and then save your form. Now your form will populate the correct manager and supervisor based on the selected employee.