Your current design means, that whenever you add a new class of documents, you have to add a new worksheet, and redesign your reports.
Better design is, where all your main data entry (document register) is in single table, with additional tables to define document classes and calculation rules. Then when you need to add a new document class, you simply define it, and the you can immediately register the document of new class without any changes in design of your application.
Added is an example workbook which illustrates this approach.
Document classes are defined in table on sheet DocClasses. Calculation rules for every class are determined by TypeCode.
TypeCodes are defined in table on sheet DueTypes.
In table on sheet Documents, columns with differently colored headers contain formulas. Columns with dark green headers are meant to display info for users. Columns with brown headers are helper columns used for calculations, and may be set hidden.
When document is delivered, it may be delivered On Time, or not On Time (Overtime). When document is not delivered jet, it may be Overtime (OnTime= FALSE), or it's due date is later than today.
At least most of reporting you wanted, you can get simply using autofilter on documents table. You also can create any number of different report sheets - when all data is in single table, then this is much easier. When you need some report you aren't able to figure out, post here what you want.
You can freely rename worksheets, Table headers, and defined Tables - all formulas in workbook will be updated automatically.
|