A1 = [workbook2.xlsx]sheet1!A1

In this case, A1 will pull the same value as A1 on sheet1! from the xlsx file named [workbook2] in the same folder.

If it's somewhere else, specify the file path, like

A1 = C:\folder\[workbook2.xlsx]sheet1!A1

This is called creating an external reference.