Drop down list with links to cells

Hi all, first post so please be gentle...

I have a list of 36 users and some data for each user all on one sheet (UserData). I was hoping to add each name into a drop down list so when I select a user it scrolls/jumps to that users data.

Was hoping to add the list as a drop down from a frozen toolbar so others can quickly go between user data. Think with the ComboBox, correct me if I'm wrong, it autocompletes if you start typing the name??

Also, the list of users comes from another sheet named 'UserNames'.

Hope that makes sense.

Any help and stages of the process appreciated as I'm fairly new to using Excel.

I have found similar posts but to be honest they go over my head a bit.

Ta.

Thanks for the fast reply.

My initial idea was to use something like a table but trying to make it all a bit slicker and learn more about macros and VB at the same time.

Appreciate the guidance though.

I won't be at my computer until later but I'll explain a bit more.

Basically I have a sheet that has 36 users with their profile data in the proceeding columns, address etc. I use this profile data as the basis of the data i have for each user on the next sheet. This data sheet in a continuous list, this is where I would like to create a drop down in the frozen header that would take me to each user location on the data sheet. Eg; Select User1, jumps to cell A10, Select User2, jumps to A40... The drop down is based on the user name column on the first sheet and although the total of 36 users will never change, their names will so would want the drop down to be dynamic if you understand what I mean.

I spent all day yesterday playing with various things I found but couldn't get any of them working. My knowledge of macros and vba is very limited.