I'm sure an expert will chime in with something better, but I've done similar
with lookup functions. don't do it direct or it will be slow. I let
everything come over to one master workbook, then use a lookup page that
consolidates the data.

"JMR" wrote:

I need to set up a spreadsheet that links to 12 others. On each of the
others there may be 100 rows(or less) of information to bring in to the
master. Is it possible to write a formula that enables the link to pull in
only rows that contain information?

I don't want blank rows between each of the 12 groups of information