='D:\[Reciepts.xls]Sheet1'!$C2

.....will return the value in the workbook Reciepts.xls from cell C2 of
Sheet1, located in the D:\ directory. Vary the values to get what you
need.........

Vaya con Dios,
Chuck, CABGx3





"jay" wrote:

How do i merger the data from multiple workbooks into one giving totals for
specfic cells?