Is there a way i can link cells in two different workbooks in particular individual cells. For example

workbook 1 has several worksheets and in one of the worksheets say Jun_07
cell c174 contents include aa/123456/07

workbook2 worksheet 2
cell k202 contents include aa/123456/07, 14/06/07