I have several workbooks that I have linked together into one. I would
like to be able to show them in the destination workbook in a long
list, without space left in between each subset of data. The issue is,
when I add a new row in the source workbook, it does not get picked up
in the destination workbook. OR, if I select beyond the actual data
subset in the source (blank rows) to allow for the possibility of
additional rows being added, then these rows get all filled with zeros
when copied into the destination - a result I cannot allow since zero
is a valid value in some columns and this skews the data analysis being
done.

Is there a way to get the additional new columns into the destination
workbook without having to initially set it up with blank rows?

Suggestions?

Thanks!

Cat