I have two Excel work books.

Work book A will be updated on a weekly basis and show hours worked.
I want work book B to show the total from work book A. I would also like
work book B to update from work book A everytime it is opened.

Any ideas?