Please help! Cell Reference To A Shared Workbook

I have a workbook with a list of locations. I parse out shared workbooks to respective regional managers. The regional managers enter contractor information and hours worked at each location. I want...