That's correct, I used the formula you provided:
[VBA]"=FF!R133C1:R133C33[/VBA]
so if it's to go into a different sheet in the new workbook you will have to change the FF part.

Btw: How did you get the recorder to do that?
I just started the recorder and went to insert name...put in the name "TotalRow" and then pasted the formula you provided using ctrl+V