How do I merge multiple worksheets in excel ?

I am exporting data to excel, from our MRP system. Once a week, we export
this data. I need a comprehensive database to keep all the data. How do I
merge all worksheets, into one???

Originally, I had the data in access however, I exported it to .xls becuase
I thought it would be easier (silly me).

Look here for a code example
http://www.rondebruin.nl/tips.htm

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


"rene" <rene@discussions.microsoft.com> wrote in message news:83165C3E-8AA3-4398-86B8-4D1D9B5EC104@microsoft.com...
>I am exporting data to excel, from our MRP system. Once a week, we export
> this data. I need a comprehensive database to keep all the data. How do I
> merge all worksheets, into one???
>
> Originally, I had the data in access however, I exported it to .xls becuase
> I thought it would be easier (silly me).
>