Im not even sure if Im on the right track €“ but I was told to get this
done, so here goes :).

I created a form on the first sheet of the workbook and the data on the
second sheet. I was able to use data validation to load the data from the
second sheet into the fields on the form, however, that will require the user
to select the data from each field. I need the user to select one key field
and the data for that customer load automatically into every field, then the
user can complete the remainder of the form.

Any help would be greatly appreciated!