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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rowema" wrote in message ...
I have a report export that has data on multiple worksheets. Each location
has a separate worksheet. I want to combine the information from each
worksheet into one master list. Each worksheet is formatted the same with the
same columns and column headings. The number of rows varies from worksheet to
worksheet. I'm looking for a way to combine the information easily.