Thank very much for explaning that SamT. Much appreciated. I knew this but didn't know it's called naming structure

In that case , there is no specific naming structure but most of the worksheets are named Table&number like Table21, Table22a, Table22b etc.


Quote Originally Posted by SamT View Post
Naming structure means that all workbooks have very similar names only differentiated by some unique identifiers.

Unique Date Identifier:
Daily report_140116.xls
Daily report_140117.xls

Unique Dept identifier:
Accounting 011620014.xls
Sales 01162014.xls

Unique Location Identifier:
Northeast Div.xls
Southwest Div.xls