I am trying to link multiple worksheets in Excel together. Specifically, I am making a workbook for a baseball league, and every team has its own sheet. They are all basically copies of each other, with just a different team name. The problem is, I am constantly updating the formulas in each sheet, adding new columns or rows for different statistics and such. This means whenever I finish adding a feature to one team, I have to copy that change thirty times. Is there any way I could set up the workbook where I have one copy of a "master sheet", where any changes I make to the master sheet get automatically copied to all the individual team sheets?

Just to be clear, I am not looking to link data from one sheet to another, I want to copy the formulas, and do it automatically. So 'Team Lookup'!CellName won't work.

Frankly I wouldn't use Excel for this purpose I would use a database like Access. Excel is a great spreadsheet, but a poor database. And that's what you need.

Scott is right regarding Access. But if you're hooked on Excel, the real goal here would still be to NOT be maintaining separate sheets, that's just missing the benefit of computers, eliminating redundant tasks, not creating new ones.

What I would do...

1) Create a SINGLE sheet with all data for all teams. This way if you ever add a new statistic column, you're only adding it on the one sheet and now it's there for every one.

2) Create a SINGLE reporting sheet where a single cell is used to select one team to "summarize", a Dashboard of sorts, then all the statistics are drawn in right now for that one team to review. This sheet can be designed any way you wish, perhaps very similar to what your current multiple sheets are.

Thanks, I will probably adapt this to Access over the summer, don't really have time right now. I have already applied the basic approach you outlined, I already have one sheet with all the necessary raw numbers and another with all the statistics. The only problem is I have to reference all of the different teams to create a standings, so I need each of them individually. I also don't want a sheet that is a million rows long just to make stats easier. Thanks for the advice though, I will probably just leave it until school ends.

I don't know if this would work but if you copy all of the relevant information that is to appear in the other worksheets then select all of the worksheets in which you want the link(s) to appear then use the paste function and choose insert link (usually the icon to the far right of the paste options) and paste the information to match the columns and rows of the master worksheet. I know pasting a link works for my ledger summary page if I make any changes to any of the worksheets for the month by month invoicing. Hope this helps.