Try this
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"PaolaAndrea" wrote in message ...
Good Morning:

I have 7 worksheets in a workbook and I would like to have an 8th worksheet
that combines all the 7 previous worksheets.

Worksheet 1 to 7 is the same as worksheet 8.

I tried a pivot table but I am not very good at it.

Please help.

Sincerely,

PaolaAndrea