You can use a DIR looping macro to open or create formulas for each workbook
desired to the next available row on the destination file.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Melwin" wrote in message
...
Want to consolidate data from many flies which are in the same format to a
sigle file how can i do it in the best way?