I have a workbook that updates daily. When it updates the updated value goes in the top row of the column lets say A3 and moves the rest of the numbers in the column down one row. I want to link these values to another workbook. What formula can I use to copy these values. example The first day it copies A3:A212 the next day A3:A213. Can anyone help?