I have a many to one workbook/spreadsheet situation. I have many workbooks that point to a single workbook A (master workbook). Each external worksheet has a unique cell that it references in workbook A column G.
Master workbook A is in alphabetical order and column G is updated frequently. From time to time, I have to add or delete a row of data in the master worksheet. When I insert or delete a row in this master worksheet... it throws off all my cell references in the external sheets.
How can I insert or delete a row in my alphabetized master worksheet A and have Excel update the cell references in the external worksheets to correspond with their new row location?
Hope that makes sense and thanks in advance for any help.