Changing sheet tab names in formulas.

[kps73066]

Here's my scenario. I have a summary sheet that references data from other sheets in the same file. The other sheets all have the exact same formatting, formulas, everything. When I have to add a sheet, I then have to add a column on the summary sheet to reference it. In turn, the added sheet will also have to reference information that is entered on the summary sheet. Is there a way using vba that, when I do have to add a new sheet Excel can automatically 1-Create and format the new column on the summary sheet? 2-Update formulas in the new column on the summary sheet obtain data from the added sheet without having to manually change the sheet tab title in the copied formula? 3-In turn, update formulas (in fixed locations through the sheet) on the added batch sheet without having to manually change the column reference each time.

Let me clarify that I'm a raw dog rookie when it comes to vba so please be patient if I don't understand right away.

Thanks.

 

[Zot]

It would be much clearer if you can use XL2BB to copy each sheet you were talking about with simple explanation.

 

[kps73066]

It would be much clearer if you can use XL2BB to copy each sheet you were talking about with simple explanation.

I found a temporary workaround. I will try to find a way to clear up my question.

Thanks