Excel Table Mirroring

I have searched all day trying to find an answer to this question and can't find exactly what I'm looking for. I'll see if I can attach an example of what I'm trying to do.

Sheet1 has a list of names in column A.
I have turned that list into a table.

Sheet2 needs to mirror that list of names, again in column A.
To do this, I labeled cell A2 on Sheet2 =Sheet1!A2 and then proceeded to click the bottom right corner of the cell and drag down to fill the area needed to mirror the entire column of the indexed table.

NOW... here's my predicament...

I fill in information in the rows next to the names that are mirrored from Sheet1 on Sheet2. My problem arises when I add or delete names from Sheet1. It reflects immediately on Sheet2, which is great, but only column one moves - meaning that the information I have put next to the names on Sheet2 is now no longer next to the correct name. This also happens if I add a name to the bottom of the list on Sheet1, and then sort them A-Z.

What I need is for the rows on Sheet2 to be locked to the first column, so when the name in the first column moves up or down, the information next to it follows it. And if I delete a name from Sheet1, I need the name on Sheet2 AND all the information next to it to also be deleted.

Does this make sense? It sounds so easy but I can't find an answer anywhere! I'm about to pull my hair out!

Thank you Richard, I changed the first column of my second sheet to reflect a VLOOKUP instead of a specific cell.

Still though, when I alter the list on Sheet1, the information that I've put next to the names on Sheet2 (in Column2), don't move to stay with the name that it goes with.

I've attached a copy of my current situation.

What I need to happen, is that when a name is added or deleted from the first sheet - which currently mirrors on the second sheet, I need the information that I've entered next to those names to STAY with the names that they're assigned to. Therefore, when something is added, it has empty spaces for me to fill in information next to their names. And when a name is deleted, all the information next to that name is deleted and the spot closes up.

Any idea how to fix that?

TMS,

That works also! So I see there are several ways to mirror the information from columnA onto both sheets and have it change when I sort the names on Sheet1... however, Column2 on Sheet2 still doesn't correspond with the names they were initially written next to.

The real-life scenario I'm trying to fix is - names from Sheet1 need Uniform Sizes listed next to them on Sheet2. When the names from Sheet1 change, I need the sizes that were listed next to the names on Sheet2 to stay with the names they were next to - and have blank spaces show up in Column2 for me to put sizes next to the new names that were added - as well as deleting old information of names that were removed.

I appreciate the help! I've been working on this all day. This site is awesome and I really appreciate the feedback!!!

Hi!
I have had the same problem recently.
Have you found the solution yet?