Thanks for the Link Rob. Just one quick question...rather than creating a
new worksheet to import the data into, I want to put all the data into a
worksheet that already exists. How would i go about doing this?

Thanks

"Ron de Bruin" wrote:

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


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



"Rooster" wrote in message ...
Hi Guys,

Im trying to do something that i think should be really simple. I have a
spreadsheet with 4 worksheets. I want to collate all the information from
the 2nd, 3rd and 4th worksheet into the first worksheet. Is there an easy way
i can do this with VB code or a macro? Selecting all the information into a
recordset and then putting it in the first worksheet? Any help would be
appreciated.

Thanks