Consolidate data with text

[John]

Excel Consolidate Data does not consolidate text. I need to somehow combine
data from several different worksheets into one (the sheets contain text and
numbers). The tables on each sheet are set up identically with identical
column headers. Ideally, I would like to import worksheet #1, then beginning
on the first blank row after worksheet #1, import (or copy and paste)
worksheet #2, etc to form one combined database. Ideas, please?

 

[James]

I should have mentioned these worksheets are in different workbooks.

 

[Dave Peterson]

Ron de Bruin has tons of code samples for combining data here:
http://www.rondebruin.nl/tips.htm