Thank you for the suggestion. How would I format the formula? Let me provide the link using my actual data.
Code:
='Z:\Financials\Sales\Cashier Return Sheets\FY2017\03\[week4.xlsx]Monday 1'!$C$50
Please let me know where to place the INDIRECT([cell name]) within the above formula.