How to activate and hide a cell when hyperlink is clicked?

Dear Pros,

I am confused. I have a final thing to do in my program. I have lists of components "Component 1" "Component 2" etc... the list are basically worksheets which contain all types of specs regarding their component (example: Component 1 [sheet] has over 100 specs of component 1...).

With that being said, I just want 1 sheet to show in my list which contains a list of all components. I have the following function in 1 cell which fetches the name. It works perfectly.

=IF(ISERROR(INDIRECT(ADDRESS(4,2,1,FALSE,"Component "&ROW($A2)),))=TRUE,"",HYPERLINK("[Components collection.xlsm]"&ADDRESS(3,2,1,FALSE,"Component "&ROW($A2)),INDIRECT(ADDRESS(3,2,1,FALSE,"Component "&ROW($A2)),)))

My issue though is that the hyperlink can't open the sheet if i hide it. In order to open it, I need to unhide it, click the hyperlink, then hide it again when I see the specs or make changes. I want to hide it because I will get over 100 components and I don't want to have over 100 tabs. I just want 1 tab.

The question is therefore:
1) How can I automatically activate and unhide the page when component name in the list (cell) is clicked (taking in mind that the hyperlink in the cell given above also fetches the name of the component in the component sheet).
2) How can I automatically hide the sheet when I switch out of it? It is tricky because I have over 100 components with sheet names that are "Component 1", ..., "Component 100",... etc.

The layout cannot be changed. Each worksheet has over 300 cells of info regarding the components. They are perfectly organized so they all look the same and each component can be properly documented.
I want all the worksheets to be hidden, expect the main one with the list. From that list, I want to be able to access the worksheets that are hidden (100+ worksheets). I need to unhide the worksheet I choose (formula above provides the hyperlink but I can't seem to be able to access it when it is hidden). I am wondering if there is a way to unhide the worksheet, activate it, then unhide it when i change back to the main sheet.

Hehe thank you! Too many components to go back on the layout now :P That's what I mean't by "can't be changed".

A lot of proprietary info! It would take too long to simplify it and remove important info. I think this requires VBA to solve