summary of all INDEXes or INDICES to another workbook

[cybrkada]

Our team has individual workbook (tracker) with date (MMDD format) on each sheet and an INDEX sheet (run by <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>) which is the summary of all sheets. Now, I want to create another workbook which will contain the INDEXes or rather INDICES of my team members'. How do I accomplish these?

Your assistance is greatly appreciated. Thanks!

 

[cybrkada]

to add: basically i want to replicate a particular sheet (which contains VBA) from different workbook and place it on a different workbook. i want it to be dynamic, which will reflect any changes you made from the source data...