I have the following formula on the first tab of my workbook:
='Original Contract'!C$2
The cell C2 is part of a query that gets refreshed when my macro runs. The query only ever has one row plus the header row. It is never blank. The data just changes depending on which job number they are...