Hi guys,

What we have are multiple workbooks (one per employee) to track projects. Each one is set up identically and I need to have a dynamic link(s) to each worksheet in each workbook.

The range of cells are A2:F# (The amount of rows is variable). Each worksheet represents a month and year (Aug 2012, Sep 2012, etc.) . I need the summary data to link to the corresponding tab in the master sheet. If an employee updates (adds/deletes/edits) his or her workbook/sheet it should cascade into the master sheet (perhaps after running a macro?).

The employee project workbooks are all in a single directory. The master workbook is one level deeper in an Admin folder.

I have toyed around with a bunch of modules and functions but have not been able to achieve any success.

Any ideas?