Check out the copy paste merge examples...
http://www.rondebruin.nl/tips.htm
--
HTH...
Jim Thomlinson
"Kyle" wrote:
I have 9 Spreadsheets consisting of contact information for publications in
different industries. 8 Industries and 1 Master List. I would like to link
the master list to all of the individual industry lists so that when I add or
update a new contact in an Industry list, it is reflected in the Master
Spreadsheet as well. Essentially, I want to cut down on duplicating my
efforts.