Thank you Admin for this works great.

Is it possible to SEARCH for text box entries, instead of it's actual values = sheets.

eg: if i enter:

231, xt249, text120, text

Search for these items in column_F then copy rows to Find sheet. Same like ISNUMBER(SEARCH(txtbox.value,InSheets)) also keep the source format?

Instead of Private Sub ComboBox1_Change(), possible to make it as SUB for a button. So users can select the sheets, enter textbox entries then can click on the button.

Thanks ton again for your help