Baisc Macro knowledge

Hi,

I only have a very basic knowledge of working with Macros and Excel so hopefully the question i'm going to ask will be relatively simple for someone to answer.

I'm creating a monitoring system for work and i'm trying to get a macro to tie in alongside a drop down menu. By this i mean that the drop down menu will give several options, i.e. the names of four seperate companies. I want to be able to select one of these companies from the drop down and then when i click on the 'submit' button i wish to be taken to that companies worksheet in the same workbook. So dependent on which company is selected i want to visit one of four worksheets by clicking the same button.

I hope this is clear...please help if you can, it will be much appreciated!

Cheers

I created the drop down by going through Data toolbar> Validation> List.

I have absolutely no idea how to use VBA either so i'm kinda blagging it!

Cheers

'Please read forum rules below. Titles like


Code:
- some assistance please!
Are not permitted

VBA Noob'

Sorry i'm a newbie...wont happen again.