Hi,
Look at Ron web page he has the solution to your needs

http://www.rondebruin.nl/copy3.htm

If this was helpful please click yes, thanks

"Amit Mahar" wrote:

Hi All,
Please help me on consolidating 580 file's data in one file without oppening
each and every file.If there is any options for importing these files into
single master sheet.
Would appriciate your help.