Populate in-cell dropdown list with values based on sheet name

Hello all,

major newbie here.
I'm not sure if and how this might be done... trying to populate dropdown lists in user sheets (one sheet per user) by looking up the data in tasks sheet based on sheet name.
Then, based on dropdown list selection, cell below will autopopulate with the second value.

I am so new to excel, I have a hard time even explaining what I need, but the attached workbook will be more descriptive.
Many thanks in advance!

Hello
I've created a number of named ranges and applied a data validation list to few of the sheets as an example. The User Name must be placed in cell A3 of each sheet. See attached example.

Hope this helps.
DBY

Thank you DBY for your prompt reply.
I am struggling somewhat to implement this solution to my worksheet, but I do prefer a bit of a struggle over a straight forward turn-key solution, as this is how I will learn.
In case I get distracted with other things, I didn't want your help to go unanswered.

Thank you again!

Thank you for the acknowledgment, just to clarify, I should have stated that the User Names do need to be grouped on the 'Tasks' sheet for this to work and strictly speaking the User Name doesn't have to be placed in cell A3 but two columns to the left and two rows down from the validation cell. This of course could be adjusted.

DBY

Wow, thank you for that little tip about having to group User Names!
Works like a charm now, thanks again!

My euphoria doesn't last too long, as it turns out the dropdown and data validation functions can't be used when workbook is opened with Google Sheets, which is to be the ultimate destination of this workbook.
Looks like my next step is a different sub-forum on here...