I want to set up a process where when Workbook “A” is opened it goes out to Workbooks “B”, “C” & “D”, copies the information from certian sheets and pastes that info into sheets already created in Workbook “A”. I tried recording a Macro but get “Run-Time Error 9 Subscript Out of Range”.
