Sandy wrote...
....
This works of course only when FFPS is open. How do I modify the formula to
incorporate PULL. I have tried PULL("'[FFPSTotal "& YEAR &".xls]"
&$R9&"'!B$13"), and get #REF!

You need to include the full drive/directory path. It's necessary when
the workbook is closed, and it does no harm when the workbook is open.