Using conditions to show/hide worksheets

[Centara]

I'm new to the forum so I wasn't sure exactly where to place this question. I'm currently in an Accounting class that is based solely on Excel and the advanced uses of it. Unfortunately, we have a final project that we have to spend many hours on so I was hoping I could start it semi-early. This means I haven't gotten to use macros yet so I'm not sure if they would be able to solve my problem. So here it is!

I'm creating an excel workbook that will allow any business or accounting student to go in and create their four year plan while giving them all of their requirements for their particular degree. One of the features I wanted to have with this program is that it wouldn't display all the worksheets for each major, but rather the ones you choose that you are associated with. I was going to have a drop down menu on the first page that allows you to choose your majors, those being accounting, or business administration with its 5 focuses. If I just allow all the worksheets to be shown, there would be 6 in total and I thought it might get confusing for a student who's only taking one of the 6. My hope is that on the first page, when you choose one of the options, it would automatically display the hidden worksheet that goes along with that major.

It's kind of complicated and I'm kind of ambitious right now. I'm not sure if this is even possible or if any of you will understand what I'm saying, but if you have any ideas on how to make this possible, it'd be great if you could share them!

Thanks