I would like a Macro to clear out all the data on my sheet and replace it with new data from the next row(s)up. My sheet is linked to 4 external books and will be getting data from 18 sheets per book. How can this be done? This data I need to link from external books are cells CDEF NOPQ XYZ AA 3:35. I do not have any issues linking or anything else only with clearing out the data and placing the new data 1 row up from the external sheets and the other data comes from the "Drawn Numbers" tab within this same book. I know I can do it by copy and paste and also write a hard formula but would like a Macro (I am not familiar enough to do myself) so I can just copy and paste into my other books.