I have 7 workbooks with 15 columns of data in each. All 15 columns have the
same labels. I need to import all the data from each workbook into a single
workbook with no gaps betweem rows and all in a single page.

Example:
Workbook 1 has 5 rows of data in 15 columns, workbook 2 has 8 rows of data
in 15 columns, workbook 3 has 25 rows of data in 15 columns, workbook 4 has
18 rows of data in 15 columns, workbook 5 has no data in 15 columns, workbook
6 has 43 rows of data in 15 columns and workbook 7 has 7 rows of data in 15
columns.

I need all this data to be imported into workbook 8 with 15 columns so the
data is in ascending rows with no gaps between rows.

How can I do this?
--
SaipanRick