Editing multiple tables on different worksheets

Hi All,
I have a workbook with many sheets (approx 30 and counting) each with identical excel tables (same number of columns with same formulas and data input fields, but differing numbers of rows). The tables have fields for input data as well as calculated fields using structured references and other excel functions in the calculated cells. Each worksheet represents a months of data, each sheet has a main data table and a summary table. All these feed into a dynamic chart dashboard.

The problem comes when I want to edit a formula, say in column "G", and do it on all 30 worksheets at the same time. Excel will not allow you to select all the worksheets to do the edit in one shot, like you can for data not in an excel table - you get the popup 'Can not make changes to a table or XML mapping when multiple sheets are selected'.

I have been using VBA to cycle through all the sheets and make the edits, but every time I need to make a change it is a pain to have to edit VBA code with the new formula or to add a new column. Is there an easier way?

What would be great is if I could have a master reference table to which all other tables look to for their form, format and formulas. Is there a way to do this? Or at least ease the pain of editing a formula?

Thanks!

Steve

The most straightforward way to do it from where you're at would probably be to wrap all the formulas into UDFs instead. Edit the VBA definition and it's automatically applied to all the calls.

Well, I hazard to guess the best long-term solution might be to stop splitting your data 30+ ways and just put it all in one table, then filter that by month for interest. Less mess, less fuss.