Excel spreadsheets: does anyone know how to nest spreadsheets?

Question

I work for a buiding maintenance company, and need to organise lists of equipment for buildings we maintain throughout the country.
What I'd like to do is to create an excel file for each customer, which opens up to display tabs along the bottom for each geographic area of the country. Clicking on a tab for a given area then reveals another workbook, with a new set of tabs for all the individual buildings within that area.
Note that I'm not talking about using hyperlinks linking to external workbook, but somehow setting the tabs to open workbooks within the same view, as opposed to individual worksheets.
I've seen this done, so I know it's possible, but I've looked extensively and can't find anything.
Any of you Excel wizards out there know how to do this?

Answer 1

One way would be to creat custom views and have an event macro select a view when a tab is opened
Custom views can be found in the "tools" option on the toolbar

here is the event macro:
Private Sub Worksheet_Activate()
ActiveWorkbook.CustomViews ("cust 1").Show
End Sub

Answer 2

the best way to find anything out is to join a excel forum where all the experts gather now do a web search for >>

free+tutorials+excel+forums check the web link below