You can check Ron de Bruin's Excel Tips page:
http://www.rondebruin.nl/tips.htm

In the Copy/Paste/Merge examples section you may find something you can use.

Hope this helps,
Miguel.

" wrote:

How can I link cells from multiple workbooks into 1 workbook?

I want to link information from many workbooks into 1 workbook to make
a sumary of all the information.

All help will be apretiated.
thnx