Formula Help

I have a workbook that captures percentages from data produced by 2 reports.  Both of these workbooks are required to open when my "Percentages" workbook is opened in order to capture these percentag...