I dont know if this will help. I have 14 workbooks that link
If I have all 14 open and add or delete a column or row from one sheet all
links are automatically changed in the others. just remember to save changes
to all files.
--
TJLV


" wrote:

I just tried and am not a programmer but I'm sure this will take less than an
hour of somebody's time. Basically I have spreadsheets (6) that need to be
automatically loaded into another ss each month by country. We're just
linking to cell references now so if one country gets added in the whole
thing gets thrown off & has to be re-linked... I just want something simple
and really need some help. Can you email if you can help? Happy to offer
some renumeration for your time. This is Excel 2000. Thank you.