Automatically Duplicate Column of One Sheet to Another

[tryingbeginner]

I have six separate sheets that follow the same structure as the table below. In each sheet, I want the first column to remain the exact same. So if I start adding/removing columns from the first sheet, I want the following five sheets to automatically duplicate. Anyone have something that might help me?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Names[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[/TR]
[TR]
[TD]Name 1 [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 2 [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name 3 [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DSCfromCFA]

G'day tb,

As written I suspect that this can only be done with VBA. However, it is not clear just what you are trying to achieve so there is still the possibility it can be done 'in cell' so to speak.

Are you suggesting that the data is the same in each of the sheets, or is it simply the column and row headers you want to match, or do you actually add and delete entire columns and rows?

Further complicating the matter is if the data is just raw data added in manually or is it from an external source or as a result of a calculation? That question is for all of the sheets, not just sheet 1.

Cheers

shane