I am trying to reference a cell in a different workbook. If I do each
individual reference with my mouse it works, but i have a lot of sheets to do
so I wanted to be able to copy and paste but it won't work.

I have one workbook that references all the others using the formula
='[04F1-10a.xls]Field 3'!$B$4. I want to be able to change field 3 to 4,5,6,
etc. When I copy the one formula multiple times it will display "4-3" which
is correct. but then when i try to change the 3 to a 4 it should display
"4-4" but instead it just displays the formula.