Hide/Unhide Tables with drop down or checked box

Hello Wizards

I am a novice at Excel but know enough o get me by. I am making a check off list in excel. We make a variety of products and thus have a variety of steps for each item. I want to know if there is a way to make a table in another page or a hidden table that will then appear on the main page once a drop down choice is made or a box is checked. Basically I have 4 types of items. Each one has a different number of check off steps. When I select one I want that corresponding table to populate. And thus the same with the others. So that was one excel spread sheet can be used for all but you dont have all the unneeded tables around.

Any help on this would be fantastic. Please be specific in explaining any help.

Thanks guys
-Alex

Haha yep novice. What's VBA macros?