I'm trying to use a formula to copy and paste between workbooks, it does everything fine except it pasting the data as values. I need the data to be able to be updated automatically.