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.
|