I have a List on Names on Sheet A, and the Same list (=Sheet A! A1) on Sheet B. In Sheet B and several other sheets in the workbook there are corresponding values on the same row in every sheet based on the list in Sheet A. The list is in Alphabetical order and I want to add a name to the list and in every other sheet have a blank row added with the new name. For Example Sheet A, A1 = Doe, Jane, A2 = Doe, John. I want to add a Insert a Cell between the two and make it, A1 = Doe, Jane, A2 = Doe, Jim, A3 = Doe, John. When the new name is inserted, I need Sheet B, A2 = Doe, Jim, but I need B2:2 to be Blank and the values that were in the same rows with Doe, Jane and Doe, John to remain the Same.