Link two work sheets together

Hi,

I managed to make an excel work book with buttons to create multiple copies of a template.

Eg. A sheet (Template) call TIPT is copied and renamed number of times as required.
If No sites is 5, then I managed to make new sheets TIPT_Site1, TIPT_Site2 ..... TIPT_Site5

what i now want to do is make calculations using data in each sheet.

I again have a template call Bandwith Calculation. Its using the data from each TIPT site.

S0, when a new site is created say TIPT site 1, I want to make a copy of Bandwith_Calc_1 and it should automaticaly select data from only TIPT site 1, If TIPT site 2 is made, make a copy of Bandwit_Calc_2 and it should use data from TIPT Site2,

Any help is much appriciated
Thankyou

In your Bandwith_Calc template sheet write formulas which refer to your TIPT template, like:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.