the worksheets is not in the same excel file..


i have 1500 excel file

like
01-01-2001.xls and 01-02-2001.xls

all these excel files are the same format

(the thing is i am trying to form a pivot table in another file called datasheet.xls)

the macro simply copies the data in 01-01-2001.xls and paste the data in datasheet.xls and offsets 1 row then copies the data in 01-02-2001.xls then paste to datasheet.xls and so on ...

is it possible