Sorry if the title is confusing...

I have a really long spreadsheet. The spread sheet lists the Work Centers for the whole shop. There are line items for each Work Center that can expand to N items. Each line item is spread over multiple columns.

Ex:
Work center Title
item 1
item 2
item 3
item N

Work Center Title
item 1
item 2
item N

Etc...

As of now, I have only grouped each Work Center in its entirity so I can at least keep them all closed for faster browsing. I have also named each range.

What I would like to do is create a drop-down that displays all the Work Center names (Broach, Lathe, CNC, etc), Select the Work Center I want to view (for editing/updating), and ONLY display the selected Work center and all it's pertaining rows of data.

Is this possible?