I have a user group of approx 100 people that is required to fill out time sheets weekly. The have to submit their timesheets in with a specific naming nominclature in a network folder. I want to have a master sheet pull from this folder and populate the calculated number of hrs from a specific cell in each sheet and have it updated weekly.

I think I can use something like this to populate the Master sheet:

=INDIRECT("'[\\Management Team\Field\TimeSheets\Time-Sheets-Central]"&B18&"-TS-"&$D$17&$E$2)

Where as B18 = the persons name and $D$17 = the name of the week in the file name and $E$2 = Calculated hrs from the cell in the sheet.

I can not get it to work. It comes up with various Reference errors. Any ideas?