Basic User list items , search, Edit from three sheets

Hi all,
I have created a basic userform with two text boxes just to learn.
I have visited other websites and examples and still unable to get it right.

I can learn by studying this one I have created.
If anyone is willing to help please.

Sheet1 has Names & Number populated from userform- works OK with 'Edit/Add' Button
Userform close button works OK

There is a List box and I want to populate data in list box by pressing search button
If I click on any name in the list then it should show in Textbox 1 & 2

To add / search /edit data from three sheets ( have identical data) I have given command buttons
'New' 'Inuse' 'Finished' ( Which are names of the sheets as well)
This should facilitate me to to that.

Please help / hint so that I can learn.

Many thanks
kind regards

Hi all,
Error in the title... It should say ...Basic UserForm list items , search, Edit from three sheets
Apology

Hi all,
To Start with.
Please guide me how do I list all entries from sheet1 ( NEW) to a list box.
When clicked on any name in the list, it populates it in the Text boxes.

many thanks
Kind regards

Hi all,
I am getting there but still need help Please. Bit slow in learning.
Thanks
Kind regards

Hi Fotis1991,
Really appriciated your help.
I have understood the helper sheet concept now.
However when we select sheet e.g. 'New' then it lists items in that. very well
But when I click on any name it will not populate them in the text boxes for me to edit it.
Am I going wrong somewhere?
Please help. We are almost there.
Kind regards

Hi again,
We were typing at the same time.
You answered the question before I had asked.
What a speed....
Really thanks
This gives me lots of material to study your codes.

Many thanks
Kind regards

It will not allow me to give feedback. I don't know why.
Here it is
Exceptional , Kind and accurate help be Fotis1991. Thanks

Indeed Sir
You dont know what your kind help means to me.
Its like a gold mine of knowledge from Gurus like you.
What I do is now study what you have done and why
Step by step.
Then it gives me insight into the codes to get understanding and Learn.
Slow but steady.
Kind regards

Hi
It just allowed me for Rep.
I have done it

Hi Again,
I will await some time and ask just one more question that I have as per rule if it is OK with you.
Apology
Kind regards

Very Grateful Sir.
Very interesting one. A lot to study
There is a issue with record.
If we select 'New' and select any existing record from list box.
It appears in the text boxes .
But when I amend them, it goes as a new entry rather than amend the existing one.

This does not happen on other sheets. It works perfectly.
I guess some where something needs small correction.
ind regards

No No Sir,
That OK. You helped me greatly.
You deserve
I am posting it as a new thread now.
Kind regards