Capabilities of For Each/Collections for Workbook Organization?

[dk54]

Hey I was wondering what some of the capabilities of excel were in using For Each to loop through Collection Object for Workbook Organization?

We are a small company that acts as a manufacturing agent for bigger companies in the production of Textiles. We use the following types of Workbooks:
1) JobCosting Workbook
2) Production Sheet
3) Shipping Plans
4) Style Sheets
5) Debit Notes
6) Invoices

I was wondering what are some of the capabilities of Excel to Create Layers of higher level work books that call the lower level workbook objects for organization. (Ex. JobCosting Workbooks call the individual Jobs)...And later a Master Workbook calls the JobCosting, Production Sheet, Shipping Plans, ...etc).

So pretty much I am creating a mini database within Excel.

Is this possible? And if so, what do you think are some cool things I can do to improve my business by sorting the data through the higher level worksheets?

 

[Norie]

I don't think there is such a hierarchy as that in Excel, certainly not a built-in one.

The basic object model is Application-Workbooks-Worksheets, where all Workbooks are on the same level.

You might be able to implement something to simulate a hierarchy of workbooks, maybe something with classes.

By the way, and you might have been expecting this, why not use a database?