I have a workbook with three sheets. The first column of each sheet has the heading "Name". Is there a way to automatically replicate the data in Column 1/Sheet 1 to Column 1 in Sheets 2 and 3? For example, if I enter "Gordon" as my first listing in Sheet 1, Column 1, how can I get that to automatically replicate in Column 1 of Sheets 2 and 3? A helpful expert recommended holding down the "Ctrl" key, then selecting each of the worksheet tabs -- but this copies ALL the data in ALL the columns, whereas I want to copy only the data in Column 1. Thank you!

Couple of ways...

If it's just a one time thing, go to the sheet you want to copy from. Select column 1. Select the first tab to which you want to copy. While holding the shift key, select the last tab to which you want to copy. You will notice that these two and all intervening tabs are now highlighted. Select A1 in this sheet. This actually selects A1 in all the highlighted sheets. Press CNTL-v. Select any unhighlighted tab to unselect those tabs.

If you expect the data to be constantly changing and you want it to update automatically, you could just have formulas referring to the cells in the first sheet.