In your Bandwith_Calc template sheet write formulas which refer to your TIPT template, like:
or
etc.
Lets assume that the current number is stored in a variable number
In main procedure copy your Bandwith_Calc template, change its name (you already mastered this with your TIPT sheets) to "Bandwith_Calc_" & number
and then, change sheetnames in formulas
Cells.Replace What:="TIPT", Replacement:="TIPT_Site_" & number, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Bookmarks