Here is how to link two workbooks and keep them in sync.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
I have two files I want to keep in sync: Link One.xlsx & Link Two.xlsx. I’ve set up the outline in Link Two to match the layout in Link One:
One way to link the data from one to the other is to click on the cell we want the linked data to sync to (Link Two cell B3), enter the equal sign (=), then click on the corresponding cell in Link One, and hit enter:
Notice the structure of the link. The file name is in square brackets [ ] followed by the sheet name and cell reference. Also note that the cell reference is an absolute cell reference, so if you want to copy cell B3 down, you need to change it to a relative cell reference:
An alternative is to highlight the source cells you want to link to (Link One.xlsx, cells B3:B13), copy those and then, on Link Two, Paste those cells using Paste Link:
Either way will link the files and keep the data in sync.