If you are trying to pull information from one cell of the source sheet to
one cell of the destination sheet, then that's what you've got.  It should
look something like:
='[Sourcebookname.xls]Source sheet name'!A1.  If it includes $ signs for
absolute addressing, such as $A$1, then you probably want to remove those if
you want to copy the formula to other cells as below.

Having ensured that you've got relative rather than absolute addressing,
then if you wish to do something equivalent for other cells on the sheet,
then merely copy your destination cell across as many rows and column as
applicable.

If you are trying to pull information from a range on the source sheet to a
cell in the destination sheet, then when you've instered an appropriate
formula in the destination sheet you can select the relevant range from the
source sheet, such as:
=AVERAGE('[Sourcebookname.xls]Source sheet name'!$A$1:$D$8)

Try an alternate method to link all cells you want.

Select a range of cells in book1......say A1:D20

Copy then switch to book2 and select a cell.

Edit>Paste Special>Paste Link>OK>Esc

Gord Dibben  MS Excel MVP

David, I checked the formula, It didn't have the parentheses, I added them. I
still cannot get the whole range.  Only A1 is coming over.  I have tried this
now on 3 different computers.  I must be doing something wrong.
I am saving the destination (blank) workbook sheet. putting the equal sign
in the address line (which puts it in the a1 cell) then going to other
workbook and sheet, I've tried highlighting the entire range, typing the
entire range, clicking on the top left corner of the page, the formula in the
destination page looks OK.  Any other ideas?

copy the A1 cell in the destination sheet and paste it wherever you want
information to show.  
the procedure you used will only activate the A! cell