How to search through multiple worksheets and display the results to your listbox

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

Hi everyone.

I have 4 working sheets in my excel file. I have a user-form which the user can search by using any of the input field and the result will be displayed in the list-box found below it

The first worksheet will serve as the launch interface while the remaining 3 sheets are the actual data worksheets

How do I search from the user-form through the 3 worksheets and have the result displayed in the list-box

Quote from rollis13

Added Cross-posting Link

Oops, is the forum the same?

Quote from royUK

Yusuf, read the Forum Rules before posting again

Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. We are here to help so help us help you!

Readthis to understand why we ask you to do this

Display More

Okay, I have taken proper note and done the needful.

Please help me out.

Quote from royUK

You expect help when you haven't responded to your previous post!!!

Hello royUK.