How do I goto a hidden worksheets without display the sheets in title sheet Bar.

[franchise]

Good day,Pls, am facing some challenges which am hoping someonecould help me out with; there's this work am working on which have five sheets, i rename the sheets as follows Main, Sales, products, settings and report.So, i want someone to help me with VBA code whereby i can hide all the sheets except the main sheet and then create a comboxbutton in each of the sheets to goto each hidden sheets and then return back to the Main sheets.Also, i created a custom box using the "Form" containing Product Name, Description, amount, save and Cancel; my question is this, is ????† possible for me to enter data from this custom box and then it will drop in some of these sheets and then save? Please, if it's possible, how do I go about it?Thanks for your anticipated response.