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