You might want to check out some of Ron's merging examples he
http://www.rondebruin.nl/tips.htm

Under the section:
Copy/Paste/Merge examples

You might even be able to use the add-in:
http://www.rondebruin.nl/merge.htm


--
Best Regards,

Luke M
"Rich Young" wrote in message
...
I have about 100 excel files that contains data in cells A1:B6 that I need
to
extract out in to a separate single excel file. I have already created a
macro that runs through each file within a specified folder, opens it,
selects the range and copies it but I not really sure how to get it to
paste
to one file without copying over existing data. Can someone please help
me
get going in the right direction. I would also be open to paste appending
it
into Access if it's easier. Just let me know if you need more
information.

Thanks,
Rich