How to search all worksheets?

Hi,

I have a userform that searches for data from my 2017 sheet.

I now have a 2018 sheet and I would like to use the same userform to search both sheets and in a years time be able to search 2019 sheet and so on...

I have asked for help on another forum so here is the link to that:
https://www.mrexcel.com/forum/excel-...stead-one.html

Any help would be much appreciated.

Thanks

Dan

Hi Sixthsense,

Thank you for your reply.

You code is partly there.

When I enter a 2018 number into the search when on the 2017 worksheet. Your code finds the correct data in the listbox but when I select that data in the listbox it shows different data on the right in the green area.

Any further help would be appreciated.

Thanks again

Dan

Thank you so much Sixthsense it's brilliant.

Will this code work now no matter how many sheets I create in future?

Thanks again for your help.

Regards

Dan