Hello all!

I'm a newbie and need some help in Excel 2007. I'm not very familiar with macros or VBA, but I definitely know how to copy and paste code

I have a workbook with 6 worksheets: "Repair work in DC", "Repair work in MD", "Repair work in VA", "Construction in DC", "Construction in MD" and "Construction in VA". I would like the user to be prompted to select what type of work (repair or construction) and then which state (DC, MD or VA) so that the correct worksheet is displayed. If that's not an option (or too complicated to explain), then I just want all of the worksheets hidden when the file is opened and then prompt the user to select the correct worksheet (1 out of the 6 I previously listed).

I know this is probably very basic for many of you but I could really use the help!!

Thanks in advance for your time!!