Hi Celeste,

See Ron de Bruin's sample code at:

Merge data from all workbooks in a folder (1)
http://www.rondebruin.nl/copy3.htm

and

Merge data from all workbooks in a folder (2)
http://www.rondebruin.nl/fso.htm


See also Ron's RDBMerge Add-in:

Merge data from all workbooks in a folder
http://www.rondebruin.nl/merge.htm



---
Regards.
Norman


"u473" wrote in message
...
For each workbook in Folder A
Copy Values & Format (not formulas) of every Sheet2
to Folder B new workbook, Sheet2 (same workbook name from Folder
A)
Next
Help appreciated.
Celeste