I am in a small office environment and have NO desire to learn Access. We
have an Excel 2007 spreadsheet used by 3 people on a network with a number of
formulas and about 4 worksheets. Obviously it gets annoying telling people
to close the spreadsheet all the time to unlock it for editing.
Consequently, I'd like to break it up into several different spreadsheets (we
each manage our own files) which are linked to a master spreadsheet.

Basically, I want to create a master sheet with connections to all three
documents, which consolidates them into one list. I leave blank space to add
information for new clients, but I don't want to copy the blank space into
the master spreadsheet. Furthermore, I don't want to have blank space in
between my linked tables. How do I draw data from all three sources and put
it into one big table?

For the record, the majority of this data is text and consequently, a
PivotTable will not work. Please let me know what options are available to
me.