I build 10 versions of the same book daily. I need to take the info that
those books spit out and put them into a single book (destination.xls).

As of now i am copy/pasting the info into the destination book and it is
taking quite a bit of time.

I figured out how to link to a single source and pull it in. (='C:\Documents
and Settings\My Documents\[source.xls]Sheet1'!A1)

Is there a way to make the name of the book a cell so i can just type in the
name of the book (in that cell), so it will pull from the I am doing and it
pulls from there.

ie

='C:\Documents and Settings\My Documents\[J1]Sheet1'!A1

then in cell J1 would be the name of the book.