i want to copy data from different workbooks..
Workbooks("sample.xls").Worksheets("sheet1").Range("A1:G4").Copy
Destination:=ActiveCell
macro copied contents from sample.xls..

then i want to append data from the other workbook(sample1.xls) depends upon
the range of the data..

this continues for n worksheets...


wat should i do for that..

kindly help me..