Drop down list with a twist?

So my spreadsheet is pretty functional thanks to some great help from here... I do however have another thing I am trying to get this thing to do... When I select "packages" from the drop down list under category and then select "XXX" (any entry here) from the product drop down list - Is it possible to have it return the corresponding grid from the "Packages Reference" sheet? And then hide the items after the first row? So say I make these selections: "Packages" and Lighting Package 1", It would return the following rows:
1 Packages Lighting Package 1 $1,052.50
3 Conventional_Lighting PAR SOURCE 4 ETC EA BLK Pre Ord
1 Lighting_Console CONS 12X 2-SCENE LEPRECON 612 Pre Ord
1 Dimmer_Power 6X 2.4K LEP LD-360 DMX-HP ED (40A MAX) Pre Ord
2 Rigging HOIST 208V 1/2-TON 16FPM CM-F SOCA7 Pre Ord
1 Rigging RIGGING PACKAGE (INCLUDED) Pre Ord
1 Truss_Pipe TRUSS BOX 12" x 12" 8' (SILVER) Pre Ord
1 Truss_Pipe TRUSS BOX 12" x 12" 10' (SILVER) Pre Ord
1 Cable CABLE PACKAGE (INCLUDED) Pre Ord

But then hide the rows to look like this:
1 Packages Lighting Package 1 $1,052.50

This is so that the inventory counts on the inventory sheet stay correct but I do not have to see the package "parts" when the package is listed. I would also like the package part counts to adjust according to the quantity entered in colmn A for the package...
Is this possible or am I reaching to far?

John,
So the story goes that I was putting this together to keep track of inventory use onsite for a large event. Then the sales team got a hold of it and want to use it for quoting purposes as well. I need the workbook to function in a way to where when I select a "Lighting Package" the inventory gets updated correctly on the inventory page. Meaning that if on one booth tab ( 1 - 75) if I enter that "package" into the line, I need it to populate with all the parts to that package. The packages references are on another sheet. But the sales team does not want to see the parts of that package listed out - they only want to see "Package 1" etc. So is it possible to have the parts list out or be applied to the inventory page but only show the first identifying line of the package shown on the booth tabs (1 - 75)? Let me know if this makes more sense...

I would like to select a lighting package from the first drop down list in tabs 1-75 starting on cell B10. Then have that selection populate more than one line - it returns the whole package which is built out and listed on another sheet within the workbook called package reference. So if I select Lighting Package 1 - it returns all of lighting package 1 into the same amount of cells as the package reference. This will populate my inventory sheet automatically and there all the different products get tallied and compared against the inventory in stock. The sales guys do not want to see the whole lighting package on the sheets 1-75. They just want the title or header or whatever you want to call it. They do not want to see the parts of that package. So is there a way to hide those rows after the drop down list populates them?