Try this...

Do this one time...Do your normal copy operation BUT instead of pasting do
Right clickPaste SpecialPaste Link.

--
Biff
Microsoft Excel MVP


"dalmom" wrote in message
...

How would I accomplish this without having both books open and copy/paste
each time?

Workbook 5, sheet 22, column 9 needs to have the data from
Workbook 1, sheet 3, column 2,

Workbook 5 needs to be able to pull the data from workbook 1 and update it
to match when I open the workbook, it needs the entire column of data.