importing sheets by browse button on userform

Hi,
I have a userform having two Tabs. i have to do with only first page named "Data Importing Tab" one TextBox and one Browse Button along with Import button.
to solve my issue i found some near solution on internet but but dint figure it out.
what i want is- i can chose excel file loacation using "Browse" Button or not then manually i can put excel file location in TextBox. Then I click on import button the macro will search sheet name "purchase" or "cash" in located excel file. when one of this two sheets available, macro should copy the entire sheet value in existing "Data Register Sheet".

Extra hint- I have two files one has "purchase" sheet and another has "cash" sheet from which i have to import the data in "Data Register Sheet'.


thanks