how to merge all worksheets into one

[jerome]

i need to merge all of my worksheets into one to import it into access. how
do i do this ?

 

[Ron de Bruin]

Hi jerome

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