Hi Angelo

Ron BeBruin has some great codes that may offer a solution for you.

Try these:

Create a summary worksheet from all worksheets (formulas with VBA)

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


Create a summary worksheet from different workbooks (formulas with VBA)

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


Delete row if a specific value exist

http://www.ronbebruin.nl/delete.htm


HTH
Mick