Copying worksheets issue

Alastair-

Thanks for your help. I'm basically trying to figure out a way to allow someone to send out the "Fee Detail" Sheets to consultants as separate workbooks. Upon receiving them completed simply paste the sheet back in the "Fee Estimate" workbook so that the "Summary Sheet" will read the "Detail" sheets and provide an over all summary.

I thought I might have a cell that has the value defined as a Name so that I could use that Name in a function and the end user could match the Name to the proper sheet and it would update all the formulas. I just can't seem to get the syntax correct.

I'd appreciate any advice.

Thanks,

Tom