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

[Yusuf_A]

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 fields 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

[rollis13]

Added Cross-posting LINK (https://www.ozgrid.com/forum/index.php?thread/1228778-how-to-search-through-multiple-worksheets-and-display-the-results-to-your-listbo/)