Clear out all cells and paste new row(s) data

[Jack-P-Winner]

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

Thanks Gurus!!!

 

[Jack-P-Winner]

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 and I just did cross post this.

http://www.ozgrid.com/forum/showthread.php?t=189453&p=718640#post718640

 

[Jack-P-Winner]

If you need an external book too I can provide one but I would think as long as you had the input name or just leave that part blank for me to fill in is fine. One book is called (SSD (Z EXCEL SHEETS........... They are all linked to a book in this drive