We have two workbooks maintained seperately.

Workbook 1 has a cell that has a total of a column that needs to be inserted
in workbook 2 daily.

My present procedure is to:
Open book 1, look at that total, write it down.
Open book 2, enter that total into appropriate cell in book 2.

Is there any way to automate this? Something like: Just by opening book 1,
it imports the data from that cell in book 2?

Sorry for the really newbie question. I hope I asked correctly.