Sorry, this is a pretty low-tech answer.

But why don't you just highlight the cells in the workbook you want to take
data from, then press "Ctrl-V" (to copy) then go into the workbook you want
to put data into, select the cell you want to start pasting the data into,
and press "Ctrl-V" to paste?

--

"SaipanRick" wrote:

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