Auto-update formulas across sheets?

[Joel.]

For a budget plan I have a source sheet from which all other sheets draw their data from. Each sheet, however, has different cell names to differentiate between them. For instance, all the columns in the January sheet get their data from the 'C' column of the source sheet. February is 'D', and so on.

Rather than manually update those references each month (there are many per sheet, two sheets per month), is there a way to make Excel update each sheet with the correct column references? All I really need is the columns to update (C to D, D to E, etc.).

[davsth]

a sample would assist, but index(match) or index(offset number) may be solutions to looks at

eg if you wish to return c2, if it says (index(c2:j2,A1) where A1 is the offset you wish to make, you just change a1 from month to month, making it one larger and all formulas update

[Joel.]

a sample would assist, but index(match) or index(offset number) may be solutions to looks at

eg if you wish to return c2, if it says (index(c2:j2,A1) where A1 is the offset you wish to make, you just change a1 from month to month, making it one larger and all formulas update

My apologies for not providing a sample. Will do so as soon as I get a chance to make one. In the meantime I've been looking at your suggestions to see if they might do the trick. Again, I need to find some spare time to experiment with it. Thanks.