Userfrom Textbox doing a Search based on Worksheet Name on the same Workbook

[choleb]

Hi, I have the Textbox and I needed to pull the data and compare it with the other worksheets.

If I put a value at the textbox, then it will automatically search this value at the worksheets with the name "Apple" and start pulls and compare the data.

The data to be pulled will be based on the value put at the "TEXTBOX"

For example:

I put an "Apple" at the text box then it will look the Worksheet Name "Apple". After finding the "apple" worksheet it will then start to pull and comapre the data between the two worksheets.

Hope you can help me on this.. I am just a novice on macro.

Thanks in advance.