I have a several worksheets with data that needs to be combined into one main
worksheet. Right now I copy the information from each one and keep adding it
the bottom of the main list. It isnt hard to do but some of the workbooks
have a lot of worksheets and I am just looking for a quick way to handle
this. I have looked at the consolidate feature and it would not work for
what I am trying to do.

Any help will be appreciated.

Jordan