I have many user files (timesheets) and a report file (payroll report) that
uses these timesheets as links. The timesheets are password-protected. I
need the report to be able to be updated without opening all the files. Is
this possible?

Thanks!