As far as I know, if you have '=[Book1]Sheet1!$A$1' in Cell A1 of
Sheet1 in Book2 then the changes will be reflected when it changes.

Have you definitely got 'Automatic' selected in
Tools-Options-Calculation. If it is manual, use F9 to calculate.