Copy formula from left to right and point to newly created tab

[bhatipuru]

=COUNTIF('05-23'!$B$1:$B$5566,"d*total")
=COUNTIFS('05-23'!$B$1:$B$4935,"D*total",'05-23'!$P$1:$P$4935,0)
=VLOOKUP("Grand Total",'05-23'!$B:$N,9,0)
=VLOOKUP("Grand Total",'05-23'!$B:$N,13,0)
These are the formulas I copy from left column. After i copy, I want to change the lookup tab to the new tab. Ex: In the above formula it is "05-23" and the new tab could be "05-24" or any tab name i assign. How can i macro to write the code.

 

[Gerald Higgins]

I'm not a VBA expert, but I just tried using Edit / Find / Replace with the Macro recorder switched on, and it gave me this -
(assuming that the formulas are in the range A1:A4)

    Range("A1:A4").Select
    Selection.Replace What:="'05-23'", Replacement:="'05-24'", LookAt:=xlPart _
        , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

It seems to work, so maybe this will get you started.
Note - there may well be better ways of doing this.