To cross-reference between spreadsheets, you must identify cells using extended addresses. These extended references specify the cell's sheet as well as its column and row.

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.