OK - so if you have both workbooks open, and in file 1 click on cell A1, then hit the equals sign (=), then click on cell B2 in file 2. Excel will now know that both workbooks are linked and each time you input a value in B2 it will copy to A1.
You can show the date and time automatically without needing to add a keyboard shortcut. In any cell input this formula
=NOW()
- you can now format the cell to suit. This will update the date and time every time you open that sheet.
Does this help?